{"text_format":"3","workbook":"xlsx","n_sheets":17,"sheets":["coverSheet","Worksheet 1","Worksheet 1b builder's plate","Worksheet 3","Worksheet 3a Overview","Worksheet 3b Overview","Worksheet 4","Worksheet 5","Worksheet 6","Worksheet 9","Worksheet 10","Worksheet 11","Worksheet 12","Worksheet 13","Worksheet 13a","Worksheet 14","Worksheet 15"],"not_rendered":{"charts":1,"images":16,"defined_names":18,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"coverSheet","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"merged":[[2,0,2,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[13,0,13,5],[15,0,15,5],[16,0,16,5],[18,0,18,1],[19,0,19,1],[21,0,22,5],[24,0,24,5],[26,0,26,5],[28,0,28,5]]}
[]
[]
["ISO 12217-3:2017 SAILING BOATS OF HULL LENGTH LESS THAN  6m"]
[]
["Manufacturer:"]
["Signatory, Name:"]
["Signatory, Title:"]
["Phone:"]
["Email:"]
["WWW:"]
["CIN Model Year:"]
["Model Name:"]
[]
["This calculation sheet is ONLY for sailing boats smaller than 6m; therefore worksheets regarding motor boats are omitted!"]
[]
["This calculation sheet is provided by IMCI \"as is\" and any express or implied warranties, including, but not limited to, the implied warranties of fitness for a particular purpose are disclaimed."]
[]
[]
["blue cells are derived values"]
["yellow cells require data input"]
[]
["Please make sure to set your signature on the summary! (worksheet 15)\neither digitally or print summary, sign and attach scan"]
[]
[]
["  - most worksheets have additional comments / remarks / other calculations beside the printout area; please take into account."]
[]
["  - For boats with quick-draining cockpit the cockpit calculation according to ISO 11812 shall be enclosed to the documentation."]
[]
["  - Please attach other detailed information as appropriate, e.g. photos, sketches etc. for sill height, openings, companion way doors, location of flooding points, practical tests etc."]

{"sheet":"Worksheet 1","index":1,"n_rows":76,"n_cols":58,"rows_kept":76,"merged":[[0,0,0,9],[0,11,0,12],[1,0,1,9],[2,0,2,9],[3,0,3,3],[4,0,4,9],[4,11,4,15],[7,0,7,5],[8,11,8,14],[12,7,13,7],[12,8,13,8],[38,11,38,12],[38,13,38,31],[41,0,41,9]]}
[{"$nulls":11},"Comments"]
["ISO 12217-3:2017 SAILING BOATS OF HULL LENGTH LESS THAN 6m",{"$nulls":11},"Derived values"]
["CALCULATION WORKSHEET No. 1",{"$nulls":11},"Input values"]
["ISO 12217-3 Sailing Boat en250115"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Design Category intended:",{"$nulls":4},"Monohull / multihull:",null,null,"Propul. type","n.a.",null,null,"If applicable, insert engine propulsion type"]
["Item",{"$nulls":5},"Symbol","Unit","Value","Ref.",null,null,"OB (Outboard engine)",null,"SD (Sterndrive engine)",null,null,"IB (Inboard engine)",{"$nulls":36},"list:","list:","list:"]
["Length of hull as in ISO 8666",{"$nulls":5},"LH","m",null,"4. Table 1",null,{"$f":"IF(I9>=6,\"Please use ISO 12217-1:2017 Worksheets\",\"\")","v":""},{"$nulls":42},"A","Monohull","OB"]
["Length of waterline in loaded arrival condition",{"$nulls":5},"Lwl","m",null,"4. Table 1",{"$nulls":44},"B","Multihull","SD"]
["Empty Craft condition mass",{"$nulls":5},"mEC","kg",null,"3.3.1",{"$nulls":44},"C",null,"IB"]
[null,"standard equipment (incl. OB engine(s))",{"$nulls":5},"kg",null,"3.4.10",null,null,"Please be aware that 3.4.10 is including OB engines weights !",{"$nulls":41},"D",null,"n.a."]
[null,"water ballast in tanks which are notified in the owner's",{"$nulls":5},"kg",null,"3.3.2"]
[null,"manual to be filled when the boat is afloat"]
["Light craft condition mass",{"$nulls":5},"mLC","kg",{"$f":"I11+I12+I13","v":{"v":0,"d":"0.0"}},"3.3.2"]
["Mass of:",{"$nulls":9},"ATTENTION"]
["Desired crew limit",{"$nulls":5},"CL"," ----",null,"3.4.2","Please insert here 100 % of the masses of the fluids."]
["Mass of:",{"$nulls":9},"For the calculation of the maximum load (mL) each fluid mass will be factored, see clause 3.4.4"]
[null,"desired crew limit at 75 kg each",{"$nulls":5},"kg",{"$f":"I17*75","v":{"v":0,"d":"0.0"}}]
[null,"provisions + personal effects",{"$nulls":5},"kg",null,"3.3.3"]
[null,"drinking water",{"$nulls":5},"kg",{"$f":"K21*0.95","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"Engine Power",null,"Dry Weight"]
[null,"fuel",{"$nulls":5},"kg",{"$f":"K22*0.95","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"kW",null,"kg"]
[null,"lubricating and hydraulic oils",{"$nulls":5},"kg",{"$f":"K23*0.95","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"0 to 1,5",0,13.7]
[null,"black water",{"$nulls":5},"kg",{"$f":"K24*0.95","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"1,6 to 2,9",1.5,18.2]
[null,"grey water",{"$nulls":5},"kg",{"$f":"K25*0.95","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"3,0 to 5,2",2.9,40.9]
[null,"water ballast",{"$nulls":5},"kg",{"$f":"K26","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"5,3 to 11,2",5.2,60]
[null,"any other fluids carried aboard (e.g. bait tanks)",{"$nulls":5},"kg",{"$f":"K27*0.95","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"11,30 to 18,7",11.2,104.5]
[null,"stores, spare gear and cargo (if any)",{"$nulls":5},"kg",null,"3.3.3",{"$nulls":44},"18,8 to 33,6",18.7,124.1]
[null,"optional equipment and fittings not included in basic outfit",{"$nulls":5},"kg",null,"3.3.3",{"$nulls":44},"33,7 to 44,8",33.6,161.7]
[null,"inflatable life raft(s) ",{"$nulls":5},"kg",null,"3.3.3",{"$nulls":44},"44,9 to 56,0",44.8,188.5]
[null,"other small boats carried aboard",{"$nulls":5},"kg",null,"3.3.3",{"$nulls":44},"56,1 to 74,6",56,207.6]
[null,"margin for future additions",{"$nulls":5},"kg",null,"3.3.3",{"$nulls":44},"74,7 to 108,2",74.6,258.6]
["Maximum load = sum of above masses",{"$nulls":5},"mL","kg",{"$f":"SUM(I19:I32)","v":{"v":0,"d":"0.0"}},"3.3.3",{"$nulls":44},"108,3 to 164,1",108.2,260.7]
["Maximum Load condition mass",{"$nulls":5},"mLDC","kg",{"$f":"I15+I33","v":{"v":0,"d":"0.0"}},"3.3.4",{"$nulls":4},"Check your loaded arrival condition mass:",{"$nulls":39},"164,2 and over",164.1,312.5]
["mass to be removed for loaded arrival condition",{"$nulls":6},"kg",null,"3.3.5",{"$nulls":4},"   mLA: boat in the maximum load condition minus 85 % of the maximum capacity of fixed or portable storage tanks for fuel, oils and drinking water, and minus 90 % of edible stores, but including the worst combination of optional fittings or equipment with respect to stability"]
["Loaded Arrival condition mass",{"$nulls":5},"mLA","kg",{"$f":"I34-I35","v":{"v":0,"d":"0.0"}},"3.3.5",{"$nulls":5},"maximum value:",{"$f":"I33+I15-0.85*100/95*(I21+I22+I23)","v":{"v":0,"d":"0.0"}},null,"minimum value:",{"$f":"I33+I15-0.85*100/95*(I21+I22+I23)-0.9*I20","v":{"v":0,"d":"0.0"}},"pending on mass of edible stores included in provisions + personal effects"]
["Maximum load for the builder's plate acc to ISO 14946:2021",{"$nulls":5},"mMBP","kg",{"$f":"MIN('Worksheet 1b builder''s plate'!S6,'Worksheet 1b builder''s plate'!I24)","v":{"v":0,"d":"0.0"}}]
["Is boat sail or non-sail?",{"$nulls":5},"Symbol","Unit","Value","Ref.",{"$nulls":4},"75 kg where LH ≤ 8 m, 150 kg where 8 m < LH ≤ 16 m, 225 kg where 16 m < LH ≤ 24 m"]
["reference sail area according to ISO 8666",{"$nulls":5},"AS","m2",null,"3.4.8"]
["sail area / displacement ratio = AS / (mLDC)2/3",{"$nulls":6}," -----",{"$f":"I39/(I34)^(2/3)","v":{"$error":"#DIV/0!"}},"3.1.2"]
["CLASSIFIED AS [non-sail if AS / (mLDC)2/3 < 0.07]",{"$nulls":5},"SAIL/NON-SAIL ?",null,{"$f":"IF(I39=\"\",\"\",IF(I39/I34^(2/3)<0.07,\"NON-SAIL\",\"SAIL\"))","v":""},"3.1.2"]
["If SAIL, GO TO WORKSHEET No.3    If NON-SAIL, use checklists ISO 12217-3 power boats smaller than 6m\nNB: If boat is sailing but is also equipped for use as a non-sailing boat, both must be examined",{"$nulls":24},"ISO 12217-3:2017"]
[{"$nulls":25},"Table F.1 — Mass of single-engine installations"]
[{"$nulls":25},"Engine power","Engine + controls",null,"Battery",{"$nulls":28},"kW gesamt"]
[{"$nulls":54},"list:","list:",null,{"$f":"R43*R42","v":0}]
[{"$nulls":25},"kW","kg",null,"kg",{"$nulls":25},"SAIL","Yes"]
[{"$nulls":26},"Column 1","Column 2","Column 3","Column 4",{"$nulls":24},"NON-SAIL","No, portable tank"]
[]
[{"$nulls":26},"Dry","Swamp","Dry","Swamp"]
[{"$nulls":25},"0 to 1,5",13.7,11.7,"-","-"]
[{"$nulls":25},"1,6 to 2,9",18.2,15.5,"-","-"]
[{"$nulls":17},{"$f":"COUNTIF(R44:R50,\"Yes\")","v":0},{"$nulls":7},"3,0 to 5,2",40.9,34.8,"-","-"]
[{"$nulls":25},"5,3 to 11,2",60,51,9.1,5]
[{"$nulls":25},"11,30 to 18,7",104.5,88.9,20.5,11.4]
[{"$nulls":25},"18,8 to 33,6",124.1,106.2,20.5,11.4]
[{"$nulls":25},"33,7 to 44,8",161.7,138.2,20.5,11.4]
[{"$nulls":25},"44,9 to 56,0",188.5,161,20.5,11.4]
[{"$nulls":25},"56,1 to 74,6",207.6,177.2,20.5,11.4]
[{"$nulls":25},"74,7 to 108,2",258.6,220.5,20.5,11.4]
[{"$nulls":25},"108,3 to 164,1",260.7,222.3,20.5,11.4]
[{"$nulls":25},"164,2 and over",312.5,266.3,20.5,11.4]
[]
[]
[]
[{"$nulls":25},"Table F.2 — Mass of twin-engine installations"]
[{"$nulls":25},"Total engine power","Engine + controls",null,"Battery"]
[]
[{"$nulls":25},"kW","kg",null,"kg"]
[{"$nulls":26},"Column 1","Column 2","Column 3","Column 4"]
[{"$nulls":27},"Swamp",null,"Swamp"]
[{"$nulls":26},"Dry",null,"Dry"]
[{"$nulls":25},"37,6 to 67,2",247.9,212.2,40.9,22.7]
[{"$nulls":25},"67,3 to 89,6",323.3,276.2,40.9,22.7]
[{"$nulls":25},"89,7 to 112,0",376.8,321.8,40.9,22.7]
[{"$nulls":25},"112,1 to 149,2",415,354.2,40.9,22.7]
[{"$nulls":25},"149,3 to 216,4",517.1,440.9,40.9,22.7]

{"sheet":"Worksheet 1b builder's plate","index":2,"n_rows":69,"n_cols":56,"rows_kept":69,"merged":[[0,14,0,15],[1,0,1,10],[3,0,3,10],[3,17,3,24],[3,25,3,32],[3,33,3,40],[3,41,3,48],[3,49,3,56],[3,57,3,64],[3,65,3,72],[3,73,3,80],[3,81,3,88],[3,89,3,96],[3,97,3,104],[3,105,3,112],[3,113,3,120],[3,121,3,128],[3,129,3,136],[3,137,3,144],[3,145,3,152],[3,153,3,160],[3,161,3,168],[3,169,3,176],[3,177,3,184],[3,185,3,192],[3,193,3,200],[3,201,3,208],[3,209,3,216],[3,217,3,224],[3,225,3,232],[3,233,3,240],[3,241,3,248],[3,249,3,256],[5,0,20,10],[6,23,7,23],[6,24,7,25],[6,26,7,27],[8,24,8,25],[8,26,8,27],[22,0,22,7],[23,0,23,7],[24,0,24,7],[25,0,25,7],[26,0,26,7],[34,3,35,9],[35,23,36,23],[35,24,36,25],[35,26,36,27],[36,3,36,9],[37,3,38,9],[37,24,37,25],[37,26,37,27],[39,1,41,2],[41,3,42,3],[41,6,42,7],[41,8,42,8],[43,1,46,2],[56,3,57,9],[57,23,58,23],[57,24,58,25],[57,26,58,27],[58,3,58,9],[59,3,60,9],[59,24,59,25],[59,26,59,27],[61,1,63,2],[63,3,64,3],[63,6,64,7],[63,8,64,8],[68,6,68,7]]}
[{"$nulls":14},"Comments"]
["ISO 12217-1:2017 / ISO 14945:2021   CALCULATION WORKSHEET No.1b  Builder's plate ",{"$nulls":14},"Derived values"]
[{"$nulls":15},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Since 2021-12-09 EN ISO 14945:2021 and EN ISO 14946:2021 are harmonised!\nThe formely 'Maximum recommended load for builder's plate' became  'Maximum load for the builder's plate', mMBP.  \nmMBP does not include the optinonal equipment anymore; also the weight of outboard engines is excluded from mMBP and can be shown in a seperated line on the plate.\nBelow you find two examples for the builder's plates with the maxium value for mMBP calcuated from the stability calculation on worksheet 1; one for craft powered by outboard engines, one for craft powered by inboard or sterndrive engines.\nFor portable tanks, please change the default 'yes' on the right side in 'no, portable tank'; the weight of the tank will be included in mMBP\nPlease be aware that ISO 14946:2021 allowes in clause 6 that the maximum recommended load can be downrated or limited by the manufacturer at any time. Therefore you find a extra cell to enter a manual reduced value for the maximum load for the builder's plate.\nDefault outboard engine mass is calcuated with the help of table F.1 from EN ISO 12217-1:2017; nevertheless the manufacturer can insert the actual engine mass the boat model is calcuated with.\nThis is strongly recommended for engines with more than 164,2 kW which are outside the table range (means all 300, 350, 400, 450 and more HP outboard engines) !\nPlease be also aware that the design of these plates is just a proposal from EN ISO 14945, the manufacturer is free to change the design as long all requirements of the standard are fulfilled.",{"$nulls":16},"maximum load for the builder's plate acc. to EN ISO 14945:2021:",{"$f":"'Worksheet 1'!I19+'Worksheet 1'!I20+'Worksheet 1'!I28+'Worksheet 1'!I30+'Worksheet 1'!I31+'Worksheet 1b builder''s plate'!T16","v":0},"kg"]
[]
[]
[{"$nulls":17},"water in fixed tank(s)?","Yes",{"$f":"IF(S9=\"Yes\",\"\",'Worksheet 1'!I21)","v":""},"kg"]
[{"$nulls":17},"fuel in fixed tank(s)?","Yes",{"$f":"IF(S10=\"Yes\",\"\",'Worksheet 1'!I22)","v":""},"kg"]
[{"$nulls":17},"oils in fixed tank(s)?","Yes",{"$f":"IF(S11=\"Yes\",\"\",'Worksheet 1'!I23)","v":""},"kg"]
[{"$nulls":17},"black water in fixed tank(s)?","Yes",{"$f":"IF(S12=\"Yes\",\"\",'Worksheet 1'!I24)","v":""},"kg"]
[{"$nulls":17},"grey water in fixed tank(s)?","Yes",{"$f":"IF(S13=\"Yes\",\"\",'Worksheet 1'!I25)","v":""},"kg"]
[{"$nulls":17},"water ballast in fixed tank(s)?","Yes",{"$f":"IF(S14=\"Yes\",\"\",'Worksheet 1'!I26)","v":""},"kg"]
[{"$nulls":17},"other fluids in fixed tank(s)?","Yes",{"$f":"IF(S15=\"Yes\",\"\",'Worksheet 1'!I27)","v":""},"kg"]
[{"$nulls":18},"mass of portable tanks to be included in mMBP",{"$f":"SUM(T9:T15)","v":0},"kg"]
[]
[{"$nulls":18},"number of portable tanks to be included in builder's plate mass",{"$f":"7-COUNTIF(T9:T15,\"\")","v":0}]
[]
[]
[]
[]
["Item",{"$nulls":7},"Value","Unit","Ref.",{"$nulls":42},"Engine Power",null,"Dry Weight"]
["Manually reduced value for the 'Maximum load for the builder's plate mMBP",{"$nulls":8},"kg","EN ISO 14945, cl. 6,\n note 2",{"$nulls":42},"kW",null,"kg"]
["Maximum engine power of a single engine",{"$nulls":8},"kW",{"$nulls":43},"0 to 1,5",0,13.7]
["Maximum number of engines"]
["Actual value of the max. outboard engine mass,  (sum of all engines) as defined by the manufacturer and used for stability calcuation (default value is table F.1  from ISO 12217-1:2017 value)",{"$nulls":8},"kg","EN ISO 12217-1:2017\n table F.1",null,"please insert actual OB engine weight; see also default value calculation of engien weight with Table F.1 from ISO 12217-1",{"$nulls":40},"1,6 to 2,9",1.5,18.2]
[]
["Please see builder's plate example with values calculated from worksheet 1 entries on next page:",{"$nulls":52},"3,0 to 5,2",2.9,40.9]
[]
[]
["Builder's plate information for craft powered by outboard engines -- Example",{"$nulls":12},"number of outboard engines",{"$f":"I26","v":0},"weight of single engine:",{"$nulls":37},"5,3 to 11,2",5.2,60]
[{"$nulls":13},"kW of single OB engine",{"$f":"I25","v":0},{"$f":"IF(O32=\"\",\"\",LOOKUP(O33,BC25:BC40,BD25:BD40))","v":13.7},"kg",{"$nulls":36},"11,30 to 18,7",11.2,104.5]
[{"$nulls":15},"weight of OB engines*",{"$nulls":37},"18,8 to 33,6",18.7,124.1]
[{"$nulls":3},{"$f":"coverSheet!B5","v":0},{"$nulls":11},{"$f":"IF(O32=\"\",\"\",P33*O32)","v":0},"kg",{"$nulls":36},"33,7 to 44,8",33.6,161.7]
[{"$nulls":12},"* default value outboard engine mass, calculated with table F.1 from EN ISO 12217-1:2017",{"$nulls":40},"44,9 to 56,0",44.8,188.5]
[{"$nulls":3},"Contact Address",{"$nulls":49},"56,1 to 74,6",56,207.6]
[null,null,"    0609",{"$f":"coverSheet!B12","v":0},{"$nulls":7},"This is not to be used as a builder's plate template!",{"$nulls":41},"74,7 to 108,2",74.6,258.6]
[{"$nulls":11},"Please be aware that EN ISO 14945:2021 has requirements for the size of letters and piktogramms",{"$nulls":41},"108,3 to 164,1",108.2,260.7]
[null,{"$f":"IF('Worksheet 1'!$D$7=\"\",\"\",'Worksheet 1'!$D$7)","v":""},{"$nulls":9},"For module F, G, PCA the number of the notified body must be added next to the CE mark, for all other modules this is not mandatory",{"$nulls":41},"164,2 and over",164.1,312.5]
[]
[{"$nulls":3},{"$f":"'Worksheet 1'!$I$17","v":0},null,null,{"$f":"IF('Worksheet 1'!J7<>\"OB\",\"n.a.\",IF(I24=\"\",S6,IF(I24>S6,S6,I24)))","v":"n.a."},null,"kg"]
[]
[]
[]
[]
[{"$nulls":3},"  max.",null,{"$f":"IF('Worksheet 1'!J7<>\"OB\",\"n.a.\",I25*I26)","v":"n.a."},"kW",null,{"$f":"IF('Worksheet 1'!J7<>\"OB\",\"n.a.\",IF(I27=\"\",P35,I27))","v":"n.a."},"kg"]
[]
[]
[]
[null,null,{"$f":"IF(OR($F$49=\"\",'Worksheet 1'!$D$7=\"\"),\"\",IF('Worksheet 1b builder''s plate'!$BD$24=1,\"\",\"impossible combination of design category and option\"))","v":""}]
[]
[]
["Builder’s plate information for craft powered by inboard or sterndrive engines"]
[]
[]
[{"$nulls":3},{"$f":"coverSheet!B5","v":0}]
[]
[{"$nulls":3},"Contact Address"]
[null,null,"    0609",{"$f":"coverSheet!B12","v":0}]
[]
[null,{"$f":"IF('Worksheet 1'!$D$7=\"\",\"\",'Worksheet 1'!$D$7)","v":""}]
[]
[{"$nulls":3},{"$f":"'Worksheet 1'!$I$17","v":0},null,null,{"$f":"IF('Worksheet 1'!J7=\"OB\",\"n.a.\",IF(I24=\"\",S6,IF(I24>S6,S6,I24)))","v":0},null,"kg"]
[]
[]
[]
[]
[{"$nulls":4},"  max.",null,{"$f":"IF('Worksheet 1'!J7=\"OB\",\"n.a.\",I25*I26)","v":0},null,"kW"]

{"sheet":"Worksheet 3","index":3,"n_rows":57,"n_cols":55,"rows_kept":57,"merged":[[0,9,0,10],[1,0,1,7],[3,0,3,7],[3,8,3,15],[3,16,3,23],[3,24,3,31],[3,32,3,39],[3,40,3,47],[3,48,3,55],[3,56,3,63],[3,64,3,71],[3,72,3,79],[3,80,3,87],[3,88,3,95],[3,96,3,103],[3,104,3,111],[3,112,3,119],[3,120,3,127],[3,128,3,135],[3,136,3,143],[3,144,3,151],[3,152,3,159],[3,160,3,167],[3,168,3,175],[3,176,3,183],[3,184,3,191],[3,192,3,199],[3,200,3,207],[3,208,3,215],[3,216,3,223],[3,224,3,231],[3,232,3,239],[3,240,3,247],[3,248,3,255],[5,0,5,5],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,7],[37,2,37,3],[40,0,40,5],[41,0,41,5],[42,0,42,5]]}
[{"$nulls":9},"Comments"]
["ISO 12217-3:2017  CALCULATION WORKSHEET No.3  SAIL BOAT TESTS TO BE APPLIED",{"$nulls":9},"Derived values"]
[{"$nulls":10},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Question",{"$nulls":5},"Answer","Ref."]
["Is boat fully enclosed?          (see definition in ref.)  ",{"$nulls":6},"3.1.5",{"$nulls":44},"list:"]
[{"$nulls":52},"Yes"]
[null,"Item",null,null,"Symbol","Unit","Value","Ref.",{"$nulls":44},"No"]
["Lenght of hull",{"$nulls":3},"LH","m",{"$f":"'Worksheet 1'!I9","v":{"v":0,"d":"0.00"}},"4. Table 1"]
["Beam of hull",{"$nulls":3},"BH","m",null,"4. Table 1"]
["Beam of waterline",{"$nulls":3},"Bwl","m",null,"4. Table 1",null,"Beam waterline according to ISO 8666 on the loaded waterline. "]
["Freeboard amidships",{"$nulls":3},"FM","m",null,"4. Table 1",null,"In case of multihulls BWL is the sum of the maximum waterline beam of each of the hulls !!"]
[]
["Choose any ONE of the following options and use all the worksheets indicated for that option."]
[]
["Option No.",null,null,"7a","8a","9a","10b",11,{"$nulls":45},{"$f":"CONCATENATE('Worksheet 1'!D7,'Worksheet 3'!E38)","v":""},{"$f":"COUNTIF(BA18:BA27,#REF!)","v":0}]
["Design categories possible",null,null,"C and D","C and D","C and D","C and D","C and D",{"$nulls":44},"D7"]
["Applicable to hull type",null,null,"All","Monohull\nonly","Monohull\nonly","Monohull\nonly","Multihull\nonly",{"$nulls":44},"C8"]
["Decking or covering",null,null," All boats except 'fully enclosed' c"," All boats except 'fully enclosed' c"," All boats except 'fully enclosed' c"," Fully enclosed"," Fully enclosed",{"$nulls":44},"C9"]
[{"$nulls":52},"D9"]
["Downflooding openings",{"$nulls":5},4,4,{"$nulls":44},"C10"]
["Downflooding height test",{"$nulls":5},"4 or 5","4 or 5",{"$nulls":44},"D10"]
["Recess size",{"$nulls":5},"6d","6d",{"$nulls":44},"C11"]
["Flotation standard design cat. C",{"$nulls":3},"Level","Level",{"$nulls":46},"D11"]
["Flotation standard design cat. D",{"$nulls":3},"Basic","Basic"]
["Flotation test design cat. C",{"$nulls":3},9,"9e"]
["Flotation test design cat. D",{"$nulls":3},"9 or 10","9 or 10",null,10]
["Flotation elements",null,null,"annex D","annex D","annex D",null,"annex D"]
["Capsize recovery test",null,null,11]
["Knockdown recovery test",{"$nulls":3},12,null,12]
["Wind stiffness test",{"$nulls":4},"13f",null,"13fg"]
["Inverted buoyancy",{"$nulls":6},10]
["Detection and removal of water",null,null,14,14,14,14,14]
["SUMMARY",null,null,15,15,15,15,15]
["a  Boats using options 7,8 and 9 are considered to be susceptible to swamping when used in their design category, excepting those boats using \n    option 9 and covered by the excemptions given in footnote e.\nb  Alternatively, boats may be assessed using ISO 12217-2.\nc  That is, any boat that is not 'fully enclosed', thus including boats without any decking.\nd  Only applicable to boats of design category C.\ne  Flotation testing is not required for boats satisfying the exemptions given in 7.4.1 or 7.4.2.\nf  Only applicable to boats with mEC > 300 kg.\ng Only applicable to design cat D."]
[{"$nulls":53},"list:"]
[null,null,"Option selected",{"$nulls":49},{"$f":"E38","v":0},7]
[{"$nulls":52},{"$f":"CONCATENATE('Worksheet 1'!D7,'Worksheet 3'!BA38)","v":"0"},8]
[{"$nulls":53},9]
[{"$nulls":53},10]
[{"$nulls":53},11]
[]
[]
[]
[]
[]
[{"$nulls":52},"C7"]
[{"$nulls":52},"D7"]
[{"$nulls":52},"C8"]
[{"$nulls":52},"D8"]
[{"$nulls":52},"C9"]
[{"$nulls":52},"D9"]
[{"$nulls":52},"C10"]
[{"$nulls":52},"D10"]
[{"$nulls":52},"C11"]
[{"$nulls":52},"D11"]

{"sheet":"Worksheet 3a Overview","index":4,"n_rows":56,"n_cols":27,"rows_kept":56,"merged":[[0,13,0,14],[1,0,1,7],[3,0,3,7],[9,8,12,11],[55,0,57,6]]}
[{"$nulls":13},"Comments"]
["ISO 12217-3:2017   CALCULATION WORKSHEET No.3a   DOWNFLOODING OPENINGS / \nCLOSING APPLIANCES",{"$nulls":13},"Derived values"]
[{"$nulls":14},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["General overview downflooding openings and closing appliances",{"$nulls":25},"list"]
[]
["NOTE: All drawings are not blocked by a password, so please replace with own drawings if at hand."]
["NOTE: See X,Y, Z coordinates for worksheet 3b as illustrated below"]
[{"$nulls":8},"Please drag numbered labels to appropriate position\nPlease use same numbers only for the same opening",{"$nulls":17},"downflooding opening"]
["Top View",{"$nulls":25},"non pre-fabricated closing appliances"]
[{"$nulls":26},"pre-fabricated closing appliances"]
[{"$nulls":26},"seacock"]
[{"$nulls":26},"other devices"]
{"$rows_empty":9}
["Side View Starboard"]
{"$rows_empty":13}
["Side View Port"]
{"$rows_empty":17}
["Please insert a short describtion and measurements of downflooding openings and closing appliances under the corresponding number on worksheet 3b"]

{"sheet":"Worksheet 3b Overview","index":5,"n_rows":35,"n_cols":27,"rows_kept":35,"merged":[[0,9,0,10],[0,13,0,14],[1,0,1,7],[3,0,3,7],[7,0,7,7],[9,0,9,1],[9,6,9,7],[10,0,10,1],[10,6,10,7],[11,0,11,1],[11,6,11,7],[12,0,12,1],[12,6,12,7],[13,0,13,1],[13,6,13,7],[14,0,14,1],[14,6,14,7],[15,0,15,1],[15,6,15,7],[16,0,16,1],[16,6,16,7],[17,0,17,1],[17,6,17,7],[18,0,18,1],[18,6,18,7],[19,0,19,1],[19,6,19,7],[20,0,20,1],[20,6,20,7],[21,0,21,1],[21,6,21,7],[22,0,22,1],[22,6,22,7],[23,0,23,1],[23,6,23,7],[24,0,24,1],[24,6,24,7],[25,0,25,1],[25,6,25,7],[26,0,26,1],[26,6,26,7],[27,0,27,1],[27,6,27,7],[28,0,28,1],[28,6,28,7],[29,0,29,1],[29,6,29,7],[30,0,30,1],[30,6,30,7],[31,0,31,1],[31,6,31,7],[33,0,33,7],[34,0,34,7]]}
[{"$nulls":9},"Comments"]
["ISO 12217-3:2017   CALCULATION WORKSHEET No.3b   DOWNFLOODING OPENINGS",{"$nulls":9},"Derived values"]
[{"$nulls":10},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["General overview downflooding openings and closing appliances",{"$nulls":25},"list"]
[]
["NOTE: Please submit for every pre-fabricated closing appliance a declaration of conformity (DoC) of the product. \nPlease submit for every non pre-fabricated closing appliance a calculation acc. to ISO 12216 (see IMCI template). \nFor both a watertightness test must be done!"]
[]
["Description of the downflooding opening / \nclosing appliance",null,"Nr.","X(a)\n[m]","Y\n[m]","Z (=hD)\n[m]","opening type(b)",{"$nulls":19},"downflooding opening"]
[null,null,1,{"$nulls":6},"if necessary please submit a picture or a technical drawing of the opening or closing appliance ",{"$nulls":16},"non pre-fabricated closing appliances"]
[null,null,2,{"$nulls":23},"pre-fabricated closing appliances"]
[null,null,3,{"$nulls":23},"other devices"]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[]
["(a) Please be aware that X is measured from the aft end of LH. \nIn Annex A calculations xD is measured from the bow or stern, whichever is nearest"]
["(b) opening typs are: normal downflooding openings without any opening appliances; pre-fabricated opening appliances; non-pre-fabricated opening appliances and other devices"]

{"sheet":"Worksheet 4","index":6,"n_rows":41,"n_cols":60,"rows_kept":41,"merged":[[0,10,0,11],[1,0,1,8],[3,0,3,8],[6,0,6,6],[15,0,16,4],[15,5,16,5],[17,7,17,8],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,26,0],[23,1,24,2],[23,3,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[25,1,26,2],[25,3,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[27,0,27,4],[28,0,28,4],[29,0,29,6],[29,7,29,8],[30,0,30,7],[36,0,36,6]]}
[{"$nulls":10},"Comments"]
["ISO 12217-3:2017    CALCULATION WORKSHEET No. 4   DOWNFLOODING",{"$nulls":10},"Derived values"]
[{"$nulls":11},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Downflooding Openings:"]
["Question",{"$nulls":6},"Answer","Ref."]
["Have all appropriate downflooding openings been identified?",{"$nulls":7},"3.2.1",{"$nulls":42},{"$f":"IF(H8=\"Yes\",1,0)","v":0},"list:","list"]
["Have potential downflooding openings within the boat been identified?",{"$nulls":7},"6.3.1.4",{"$nulls":42},{"$f":"IF(H9=\"Yes\",1,0)","v":0},"Yes","required"]
["Do all closing appliances satisfy ISO 12216?",{"$nulls":7},"6.3.1.1",{"$nulls":42},0,"No","not required"]
["Hatches or opening type appliances are not fitted below minimum height above waterline?",{"$nulls":7},"6.3.1.2",{"$nulls":42},0]
["Seacocks comply with requirements?",{"$nulls":7},"6.3.1.3",{"$nulls":42},0]
["Categories possible:  C or D if all are YES",{"$nulls":6},{"$f":"IF(AZ14=5,'Worksheet 1'!D7,\"Fail\")","v":"Fail"},"6.3.1"]
[{"$nulls":51},{"$f":"SUM(AZ8:AZ13)","v":0}]
["Downflooding Height:"]
["Downflooding height test required according to clause 6.3.2.1 ?",{"$nulls":4},"required",{"$nulls":4},"6.3.2.1: The downflooding height test is not required to be conducted on the following boats:"]
[{"$nulls":10},"- those which, when tested in accordance with C.4.3, have been shown to support, in addition to the mass required by C.2 and Table C.5, in the same location an additional equivalent dry mass (kg) of (75CL +10 % of the dry mass of stores and equipment included in the maximum total load), or"]
[{"$nulls":7},"n.a. for sail boats",null,null,"- those boats that do not take on water when heeled to 90° from the upright in the light craft condition."]
["Requirement",{"$nulls":4},"Basic require-ment","Reduced value for small openings","Reduced value at outboard","Increased value at bow",{"$nulls":43},"list"]
["Applicable to",{"$nulls":4},"all options","all options  (only if figures are used)","options \n1,3,5","options \n1,3,5,6",{"$nulls":43},"fig 3","Yes"]
["ref.",{"$nulls":4},"6.3.2.2 a)","6.3.2.2 e)","6.3.2.2 c)","6.3.2.2 b)",{"$nulls":43},"annex A","No"]
["obtained from Fig. 3  or annex A?",{"$nulls":5}," = basic x 0.75"," = basic x 0.80"," = basic x 1.15",null,"please chose either fig 3 or annex A"]
["Maximum area of small openings (50LH2) (mm2) =",{"$nulls":5},{"$f":"50*'Worksheet 1'!I9^2","v":0},"   /////////","   ////////",{"$nulls":43},"cat C only"]
["Required downflooding height hD(R)","Fig. 3/ann. A",null,"Category C",null,{"$f":"IF('Worksheet 1'!D7=\"C\",0.3,\"\")","v":""},{"$f":"IF(F24=\"\",\"\",IF(F22=\"annex A\",\"\",F24*0.75))","v":""},{"$nulls":52},4]
[{"$nulls":59},3]
[null,"Fig. 3/ann. A",null,"Category D",null,{"$f":"IF('Worksheet 1'!D7=\"D\",MAX(0.2,'Worksheet 1'!I9/24),\"\")","v":""},{"$f":"IF(F26=\"\",\"\",IF(F22=\"annex A\",\"\",F26*0.75))","v":""},{"$nulls":52},2]
[{"$nulls":59},1]
["Actual Downflooding Height hD",{"$nulls":9},"please fill in increased or reduced values (if applicable) even if using annex A, otherwise you will get 'fail' results in the summary"]
["Design Category possible",{"$nulls":4},{"$f":"IF(F22=\"\",\"\",IF(F22=\"annex A\",'Worksheet 5'!H37,IF(F28>MAX(F24,F26),'Worksheet 1'!D7,\"Fail\")))","v":""},{"$f":"IF(F22=\"\",\"\",IF(H30=\"No\",\"\",IF(F22=\"annex A\",\"n.a.\",IF(G28>MAX(G24,G26),'Worksheet 1'!D7,\"Fail\"))))","v":""},{"$nulls":3},"if annex A is choosen, F39 will show 'Fail' until worksheet 4 is filled in",{"$nulls":38},"required downflooding height:",{"$nulls":9},"Check if all downflooding req. Are ok"]
["Small openings according to 6.3.2.2e) exist                                                                                   YES / NO"]
["Design Category possible on Downflooding Height = lowest of above",{"$nulls":7},{"$f":"IF(F22=\"\",\"\",IF(BH31=0,'Worksheet 1'!D7,\"Fail\"))","v":""},{"$nulls":50},{"$f":"COUNTIF(F29:I29,\"Fail\")","v":0}]
[]
[{"$nulls":59},"Check if OB starting req are ok"]
[{"$nulls":59},{"$f":"COUNTIF(H38:H40,\"YES\")","v":0}]
[]
["Downflooding Height: Outboard boats when starting:",{"$nulls":48},"required downflooding height:"]
["Question",{"$nulls":6},"Answer","Ref."]
["Does person forward of engine weighs more than 75 kg?",{"$nulls":7},"6.3.3"]
["Does mass of engine(s) fitted comply? ",{"$nulls":7},"6.3.3",{"$nulls":43},"ok, checked"]
["Is least height from waterline to flood point greater than 0,1 m?",{"$nulls":7},"6.3.3"]
["NB: All boats fitted with externally mounted outboard engines must achieve YES to all the above.",{"$nulls":6},{"$f":"IF('Worksheet 1'!J7<>\"OB\",\"n.a.\",IF(BH34=3,\"Pass\",\"Fail\"))","v":"n.a."},"6.3.1"]

{"sheet":"Worksheet 5","index":7,"n_rows":37,"n_cols":53,"rows_kept":37,"merged":[[0,9,0,10],[1,0,1,7],[3,0,3,7],[7,0,7,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[13,0,13,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,6],[16,7,17,7],[19,0,19,1],[20,0,20,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[22,6,24,6],[22,7,24,7],[26,4,26,7],[27,4,27,7],[27,9,29,9],[28,4,28,7],[30,4,30,7],[32,0,33,0],[34,0,34,1]]}
[{"$nulls":9},"Comments"]
["ISO 12217-3:2017    CALCULATION WORKSHEET No.5     DOWNFLOODING HEIGHT",{"$nulls":9},"Derived values"]
[{"$nulls":10},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Calculation using normative annex A assuming use of option",null,null,{"$f":"'Worksheet 3'!E38","v":0}]
[]
["Item",null,"Symbol","Unit","Opening \n1","Opening \n2","Opening \n3","Opening \n4"]
["Position of openings"]
["Least longitudinal distance from bow/stern",null,"x","m"]
["Least travers distance from gunwale",null,"y","m"]
["F1 = greater of  (1 - x/LH) or (1 - y/BH) ",null,"F1"," ----",{"$f":"IF(E10=\"\",1,MAX(1-E11/'Worksheet 3'!$G$11,1-E10/'Worksheet 1'!$I$9))","v":{"v":1,"d":"1.00"}},{"$f":"MAX(1-F11/'Worksheet 3'!$G$11,1-F10/'Worksheet 1'!$I$9)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(1-G11/'Worksheet 3'!$G$11,1-G10/'Worksheet 1'!$I$9)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(1-H11/'Worksheet 3'!$G$11,1-H10/'Worksheet 1'!$I$9)","v":{"$error":"#DIV/0!"}}]
["Size of openings:"]
["Combined area of openings to top of any down-flooding opening",null,"a","mm2"]
["Longitudinal distance of opening from tip of bow",null,"x'D","m"]
["Limiting value of a = (30 LH)2",null,null,"mm2",{"$f":"(30*'Worksheet 1'!I9)^2","v":0},{"$f":"(30*'Worksheet 1'!I9)^2","v":0},{"$f":"(30*'Worksheet 1'!I9)^2","v":0},{"$f":"(30*'Worksheet 1'!I9)^2","v":0}]
["If a ≥ (30LH)2, F2 = 1,0",null,"F2"," ----",{"$f":"IF(E14=\"\",1,IF(E14>E16,1,1+E15/'Worksheet 1'!$I$9*(SQRT('Worksheet 5'!E14)/75/'Worksheet 1'!$I$9-0.4)))","v":{"v":1,"d":"1.00"}},{"$f":"IF(F14>F16,1,1+F15/'Worksheet 1'!$I$9*(SQRT('Worksheet 5'!F14)/75/'Worksheet 1'!$I$9-0.4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(G14>G16,1,1+G15/'Worksheet 1'!$I$9*(SQRT('Worksheet 5'!G14)/75/'Worksheet 1'!$I$9-0.4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H14>H16,1,1+H15/'Worksheet 1'!$I$9*(SQRT('Worksheet 5'!H14)/75/'Worksheet 1'!$I$9-0.4))","v":{"$error":"#DIV/0!"}}]
["      If a < (30LH)2, F2 = "]
["Size of recesses:"]
["Volume of recesses which are not self-draining in accordance with ISO 11812",null,"VR","m3",{"$nulls":48},"list:"]
["Is opening not a recess? Is cockpit quickdraining? Is cockpit not quickdraining?",{"$nulls":51},"opening not a recess"]
["k = VR / (LHBHFM)",null,"k"," ----",{"$f":"IF(E21=\"\",\"\",E20/'Worksheet 1'!$I$9/'Worksheet 3'!$G$11/'Worksheet 3'!$G$13)","v":""},{"$f":"F20/'Worksheet 1'!$I$9/'Worksheet 3'!$G$11/'Worksheet 3'!$G$13","v":{"$error":"#DIV/0!"}},{"$f":"G20/'Worksheet 1'!$I$9/'Worksheet 3'!$G$11/'Worksheet 3'!$G$13","v":{"$error":"#DIV/0!"}},{"$f":"H20/'Worksheet 1'!$I$9/'Worksheet 3'!$G$11/'Worksheet 3'!$G$13","v":{"$error":"#DIV/0!"}},{"$nulls":44},"quick- draining"]
["If opening is not a recess,","F3 = 1","F3"," ----",{"$f":"IF(E21=\"quick- draining\",0.7,IF(E21=\"not quick- draining\",MIN(1.2,0.7+E22^0.5),IF(E21=\"\",1.2,1)))","v":{"v":1.2,"d":"1.20"}},{"$f":"IF(F21=\"quick- draining\",0.7,IF(F21=\"not quick- draining\",MIN(1.2,0.7+F22^0.5),IF(F21=\"\",1.2,1)))","v":{"v":1.2,"d":"1.20"}},{"v":1.2,"d":"1.20"},{"v":1.2,"d":"1.20"},{"$nulls":44},"not quick- draining"]
["If recess is quickdraining,     ","F3 = 0.7"]
["If recess is not quick draining,","F3 = (0.7 + k0.5); max. 1,2",{"$nulls":7},"F3 is the recess size factor, greater than 0,7 but never to be taken as greater than 1,2:\n\n "]
["Displacement:"]
["Loaded displacement volume   (see 3.5.2, EN ISO 8666)",null,"VD","m3",{"$f":"'Worksheet 1'!I34/1025","v":{"v":0,"d":"0.00"}}]
["B = BH for monohulls, BWL for multihulls",null,"B","m",{"$f":"IF('Worksheet 1'!H7=\"\",\"\",IF('Worksheet 1'!H7=\"Monohull\",'Worksheet 3'!G11,'Worksheet 3'!G12))","v":""},{"$nulls":4},"In case of multihulls, BWL is the sum of the maximum waterline beam of each of the hulls"]
["F4 = [(10 VD)/(LH B2)]1/3",null,"F4"," ----",{"$f":"(10*E27/('Worksheet 1'!I9*'Worksheet 5'!E28*'Worksheet 5'!E28))^(1/3)","v":{"$error":"#VALUE!"}}]
["Flotation:"]
["For boats using option 1 or 3\nFor boats using option 4          \nFor boats using option 6\nAll other boats","F5 = 0,8\nF5 = 1,25\nF5 = 0,9\nF5 = 1","F5"," ----",{"$f":"IF(OR('Worksheet 3'!E38=1,'Worksheet 3'!E38=3),0.8,IF('Worksheet 3'!E38=4,1.25,IF('Worksheet 3'!E38=6,0.9,1)))","v":1}]
["Required calculation height: = F1F2F3F4F5LH/15",null,"hD(R)","m",{"$f":"E12*E17*E23*$E$29*$E$31*'Worksheet 1'!$I$9/15","v":{"$error":"#VALUE!"}},{"$f":"F12*F17*F23*$E$29*$E$31*'Worksheet 1'!$I$9/15","v":{"$error":"#DIV/0!"}},{"$f":"G12*G17*G23*$E$29*$E$31*'Worksheet 1'!$I$9/15","v":{"$error":"#DIV/0!"}},{"$f":"H12*H17*H23*$E$29*$E$31*'Worksheet 1'!$I$9/15","v":{"$error":"#DIV/0!"}},null,"Table A.1 — Limits on required downflooding height"]
["Required downfooding height with limits applied\n(see annex A, Table A.1)","Category C","hD(R)","m",{"$f":"IF('Worksheet 1'!$D$7=\"C\",0.3,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$7=\"C\",0.3,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$7=\"C\",0.3,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$7=\"C\",0.3,\"\")","v":""},null,"Design category","C","D",{"$nulls":38},{"$f":"MAX(E32:E34)","v":{"$error":"#VALUE!"}}]
[null,"Category D","hD(R)","m",{"$f":"IF(AND('Worksheet 1'!$D$7=\"D\",'Worksheet 3'!$E$38=5),0.4,IF('Worksheet 1'!$D$7=\"D\",0.2,\"\"))","v":""},{"$f":"IF(AND('Worksheet 1'!$D$7=\"D\",'Worksheet 3'!$E$38=5),0.4,IF('Worksheet 1'!$D$7=\"D\",0.2,\"\"))","v":""},{"$f":"IF(AND('Worksheet 1'!$D$7=\"D\",'Worksheet 3'!$E$38=5),0.4,IF('Worksheet 1'!$D$7=\"D\",0.2,\"\"))","v":""},{"$f":"IF(AND('Worksheet 1'!$D$7=\"D\",'Worksheet 3'!$E$38=5),0.4,IF('Worksheet 1'!$D$7=\"D\",0.2,\"\"))","v":""},null,"Options",10.11,10.11]
["Measured Downflooding Height:",null,"hD","m",{"$nulls":5},"hD(R)shall be not less than",0.3,0.2]
[{"$nulls":3},"Design Category possible:",{"$f":"IF(E35=\"\",\"\",IF(E35>MAX(E32:E34),'Worksheet 1'!$D$7,\"Fail\"))","v":""},{"$f":"IF(F35=\"\",\"\",IF(F35>MAX(F32:F34),'Worksheet 1'!$D$7,\"Fail\"))","v":""},{"$f":"IF(G35=\"\",\"\",IF(G35>MAX(G32:G34),'Worksheet 1'!$D$7,\"Fail\"))","v":""},{"$f":"IF(H35=\"\",\"\",IF(H35>MAX(H32:H34),'Worksheet 1'!$D$7,\"Fail\"))","v":""},null,"hD(R)shall be not more than",0.75,0.4]
[{"$nulls":6},"Lowest of above = ",{"$f":"IF(BA37>0,\"Fail\",'Worksheet 1'!D7)","v":"Fail"},{"$nulls":44},{"$f":"IF(E35=\"\",\"\",COUNTIF(E36:H36,\"Fail\"))","v":""}]

{"sheet":"Worksheet 6","index":8,"n_rows":101,"n_cols":53,"rows_kept":101,"merged":[[0,8,0,9],[2,0,2,6],[4,0,4,6],[6,4,6,6],[7,1,7,6],[7,8,7,9],[8,0,9,0],[8,1,9,1],[8,2,9,3],[8,4,8,5],[11,2,11,3],[11,4,11,5],[12,0,12,1],[12,2,12,3],[12,4,12,5],[13,0,14,1],[13,2,14,3],[13,4,14,5],[13,6,14,6],[15,0,16,1],[15,2,16,3],[15,4,16,5],[15,6,16,6],[17,0,17,1],[17,2,17,3],[17,4,17,5],[18,2,18,3],[18,4,18,5],[19,0,19,1],[19,2,19,3],[19,4,19,5],[20,0,20,1],[20,2,21,3],[20,4,21,5],[20,6,21,6],[21,0,21,1],[22,0,22,1],[22,2,22,3],[22,4,22,5],[23,0,23,1],[23,2,23,3],[23,4,23,5],[24,0,24,1],[24,2,24,3],[24,4,24,5],[26,1,26,3],[29,0,30,0],[29,1,30,1],[29,2,30,3],[29,4,29,5],[29,6,30,6],[30,4,30,5],[31,0,31,6],[32,2,32,3],[32,4,32,5],[33,2,33,3],[33,4,33,5],[34,2,34,3],[34,4,34,5],[35,2,35,3],[35,4,35,5],[36,2,36,3],[36,4,36,5],[37,2,37,3],[37,4,37,5],[38,2,38,3],[38,4,38,5],[40,0,40,6],[40,8,40,16],[41,8,41,16],[53,1,54,1],[53,2,54,3],[53,4,53,5],[53,6,54,6],[54,4,54,5],[55,1,56,1],[55,2,56,3],[55,4,56,5],[55,6,56,6],[57,0,57,2],[57,3,58,3],[57,4,58,5],[57,6,58,6],[57,52,58,52],[58,0,58,2],[59,0,59,2],[59,3,60,3],[59,4,60,5],[59,6,60,6],[59,52,60,52],[60,0,60,2],[61,0,61,2],[61,3,62,3],[61,4,62,5],[61,6,62,6],[61,52,62,52],[62,0,62,2],[64,0,64,3],[64,4,64,5],[65,0,65,3],[65,4,65,5],[66,1,66,2],[66,4,66,5],[67,1,67,2],[67,4,67,5],[68,0,68,3],[68,4,70,5],[68,6,70,6],[69,0,69,3],[70,0,70,3],[71,0,71,3],[71,4,71,5],[72,1,72,2],[72,4,72,5],[73,1,73,2],[73,4,73,5],[74,0,74,3],[74,4,76,5],[74,6,76,6],[75,0,75,3],[76,0,76,3],[77,1,77,3],[77,4,77,5],[78,0,78,1],[78,2,79,2],[78,3,79,3],[78,4,79,5],[78,6,79,6],[79,0,79,1],[80,0,80,1],[80,2,81,2],[80,3,81,3],[80,4,81,5],[80,6,81,6],[81,0,81,1],[82,0,83,3],[82,4,83,5],[82,6,83,6],[85,0,85,3],[85,4,85,5],[87,0,87,3],[87,4,87,5],[88,0,88,3],[88,4,88,5],[89,0,89,1],[89,4,89,5],[90,0,90,2],[90,4,90,5],[91,0,91,2],[91,4,91,5],[92,0,92,2],[92,4,92,5],[93,0,93,2],[93,4,93,5],[95,0,95,3],[95,4,95,5]]}
[{"$nulls":8},"Comments"]
[{"$nulls":9},"Derived values"]
["ISO 12217-3:2017  CALCULATION WORKSHEET No. 6                   recess size                        ",{"$nulls":8},"Input values"]
[{"$nulls":52},1]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "},{"$nulls":51},2]
[{"$nulls":52},3]
["NB: This sheet is to be completed for the Loaded Arrival Condition.",{"$nulls":3},{"$f":"IF(OR(M8=\"C10\",M8=\"C11\"),\"calculation required\",\"calculation not applicable\")","v":"calculation not applicable"},{"$nulls":3},"This requirement is applicable only to fully enclosed boats of design category C for which the minimum freeboard to the recess coaming does not exceed LH/10",{"$nulls":43},4]
["Please submit multiple copies of this page if applicable",{"$nulls":11},{"$f":"CONCATENATE('Worksheet 1'!D7,'Worksheet 3'!E38)","v":""}]
["requirements of clause 7.3 referring to clause 6.4"]
[{"$nulls":4},"Recess ",1,"Ref.",{"$nulls":45},"list:"]
["Further exemptions according to 6.4.1"]
["Please insert minimum freeboard to the recess coaming.\nIs minimum freeboard > LH / 10?",null,"m",null,{"$f":"IF(B12>'Worksheet 1'!I9/10,\"Yes\",\"\")","v":""},null,"6.4.1"]
["Angle of vanishing stability > 90° ?                                               ",null,"YES/NO",{"$nulls":3},"6.4.1a)",{"$nulls":45},"Yes"]
["Over at least 35% of the periphery is the depth of the recess less than 3% of the max. breadth of the recess (e.g. toe rails, low bulwarks)",null,"YES/NO",{"$nulls":3},"6.4.1b)",{"$nulls":45},"No"]
[]
["At least 5% of the bulwark area positioned within the lowest 25% of the bulwark height drains overboard and the bulwark height is less than 12,5% of the  maximum breadth of the recess\n(attention, req. 1) and 2) below must get also a \"Yes\" to fullfill all requirements)",null,"YES/NO",{"$nulls":3},"6.4.1c)"]
[]
["Unobstructed drainage area from the recess on each side of the boat centreline",null,"m²",{"$nulls":3},"6.4.1d)"]
["Volume of the recess to the recess retention level",null,"m³",{"$nulls":3},"6.4.1d)"]
["Drainage area per side (m²) divided by recess volume (m³)",{"$nulls":3},{"$f":"IF(OR(E18=\"\",E19=\"\"),\"\",E18/E19)","v":""},null,"6.4.1d)",null,"meets requirements if result is >",null,"0,09 where the drainage openings are within the lowest 25 % of the recess depth",{"$nulls":41},"lowest 25%"]
["Height position of drainage area ",{"$nulls":5},"6.4.1d)",{"$nulls":3},"0,16 where the drainage openings are within the lowest 50 % of the recess depth",{"$nulls":41},"lowest 50%"]
["(lowest 25% / lowest 50% / full depth)",{"$nulls":9},"0,30 where the drainage openings are the full depth of the recess",{"$nulls":41},"full depth"]
["Requirements of 6.4.1.d) fullfilled? (attention, req. 1) and 2) below must get also a \"Yes\")",null,"YES/NO",null,{"$f":"IF(E20=\"\",\"\",IF(AND(E21=\"lowest 25%\",E20>0.09),\"yes\",IF(AND(E21=\"lowest 50%\",E20>0.16),\"Yes\",IF(AND(E21=\"full depth\",E20>0.3),\"Yes\",\"No\"))))","v":""},null,"6.4.1d)",null,"AND if req 1) and req 2) of 6.5.1 are fulfilled"]
["1) the lower edge of the drainage openings are not more than 10 mm above recess sole\nheight for at least 70 % of the width of each opening?",null,"YES/NO",{"$nulls":3},"6.4.1 c) & d)"]
["2) If drainage area is provided by an open or partially open transom, are the openings extend to the outboard sides of the recess sole on both sides?",null,"YES/NO",{"$nulls":3},"6.4.1 c) & d)"]
[]
["Is recess exempt from size limit?     If \"yes\", no further calculation required.",{"$f":"IF(OR(E7=\"calculation not applicable\",E7=\"\"),\"\",IF(OR(E12=\"Yes\",E13=\"Yes\",E14=\"Yes\",AND(E16=\"Yes\",E24=\"Yes\",E25=\"Yes\"),AND(E23=\"Yes\",E24=\"Yes\",E25=\"Yes\")),\"Yes\",\"calculation required\"))","v":""},{"$nulls":4},"6.4.1"]
[]
["Calculation methods:"]
["Item","Symbol","Unit",null,"Value",null,"Ref."]
[{"$nulls":4},{"$f":"CONCATENATE(E10,F10)","v":"Recess 1"}]
["SIMPLIFIED METHOD: Use 1), 2) or 3) below."]
["Average freeboard to loaded waterline at aft end of recess","FA","m",{"$nulls":3},"6.4.2.1"]
["Average freeboard to loaded waterline at sides of recess","FS","m",{"$nulls":3},"6.4.2.1"]
["Average freeboard to loaded waterline at forward end of recess","FF","m",{"$nulls":3},"6.4.2.1"]
["Waterline length at mLA","LWL","m"]
["Waterline breadth at mLA (for multihulls insert max. beam waterline acc. to ISO 8666)","BWL","m"]
["Maximum length of recess at the retention level (see 3.5.11)","l","m",{"$nulls":3},"6.4.2.4",null,"length of the recess to be measured in length direction of the boat! See drawing below also."]
["Maximum breadth of recess at the retention level (see 3.5.11)","b","m",{"$nulls":3},"6.4.2.4",null,"breadth of the recess to be measured in the direction of the width of the boat! See drawing."]
[]
[" - In case of assymetric recesses (e.g. bowrider, centercockpits,….), please insert length and breadth of each area below; this allows a more exact calculation using simplified method 1) or 2)",{"$nulls":7},"In case of assymetric recesses (see example) calculating with max beam and max length of the recess is giving adverse results."]
[null,"max. length","max. breadth","Unit","% loss GMT\n(option 1)","% loss GMT\n(option 2)","Ref.",null,"In this case using method 1) or 2) one can calculate the calculated percentage loss in metacentric height for every single part of the recess and add the results. Please be aware that this way of calculation is NOT possible for method 3) !"]
["Maximum length and breadth of recess part A",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B43=\"\",\"\",IF(C43=\"\",\"\",102500*B43*C43^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},{"$f":"IF(OR(B43=\"\",C43=\"\"),\"\",(B43*C43^3/12)*245/$E$74)","v":""},"6.4.2.2/3"]
["Maximum length and breadth of recess part B",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B44=\"\",\"\",IF(C44=\"\",\"\",102500*B44*C44^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},{"$f":"IF(OR(B44=\"\",C44=\"\"),\"\",(B44*C44^3/12)*245/$E$74)","v":""},"6.4.2.2/3"]
["Maximum length and breadth of recess part C",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B45=\"\",\"\",IF(C45=\"\",\"\",102500*B45*C45^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3"]
["Maximum length and breadth of recess part D",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B46=\"\",\"\",IF(C46=\"\",\"\",102500*B46*C46^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3"]
["Maximum length and breadth of recess part E",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B47=\"\",\"\",IF(C47=\"\",\"\",102500*B47*C47^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3"]
["Maximum length and breadth of recess part F",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B48=\"\",\"\",IF(C48=\"\",\"\",102500*B48*C48^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3"]
["Maximum length and breadth of recess part G",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B49=\"\",\"\",IF(C49=\"\",\"\",102500*B49*C49^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3"]
["Maximum length and breadth of recess part H",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B50=\"\",\"\",IF(C50=\"\",\"\",102500*B50*C50^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3"]
["Maximum length and breadth of recess part I",null,null,"m",{"$f":"IF($E$68=\"\",\"\",IF(B51=\"\",\"\",IF(C51=\"\",\"\",102500*B51*C51^3/12/$E$68/'Worksheet 1'!$I$36)))","v":""},"","6.4.2.2/3",null,"simplified recess areas of an open bowrider"]
["to be continued on page 2"]
[]
["page 2","Symbol","Unit",null,"Value",null,"Ref."]
[{"$nulls":4},{"$f":"CONCATENATE(E10,F10)","v":"Recess 1"}]
["Average freeboard to recess periphery ","FR","m",null,{"$f":"(E33+E34*2+E35)/4","v":0},null,"6.4.2.1"]
["= (FA + 2FS + FF) / 4"]
[{"$nulls":4},{"$f":"IF('Worksheet 1'!D7=\"A\",250*E56/'Worksheet 1'!I9,\"n.a.\")","v":"n.a."},null,"6.4.2.1",{"$nulls":45},"A"]
[]
[{"$nulls":4},{"$f":"IF('Worksheet 1'!D7=\"B\",550*E56/'Worksheet 1'!I9,\"n.a.\")","v":"n.a."},null,"6.4.2.1",{"$nulls":45},"B"]
[]
["Category C permitted percentage loss in metacentric height ",{"$nulls":3},{"$f":"IF('Worksheet 1'!D7=\"C\",1200*E56/'Worksheet 1'!I9,\"n.a.\")","v":"n.a."},null,"6.4.2.1",{"$nulls":45},"C"]
["(GMT) = 1 200 FR / LH"]
[]
["SIMPLIFIED METHOD: Use 1), 2) or 3) below.",{"$nulls":3},{"$f":"CONCATENATE(E10,F10)","v":"Recess 1"}]
["1) Loss of GMT used?    ",{"$nulls":5},"6.4.2.1"]
["Second moment of area of free-surface of recess ","SMARECESS",null,"m4",{"$f":"IF(AND(B43<>\"\",C43<>\"\"),\"Calc of different areas\",E79*E81^3/12)","v":0},null,"6.4.2.2",null,"SMARECESS = l * b³ / 12",null,null,"theor.:"]
["Metacentric height of boat at mLA","GMT",null,"m",null,null,"6.4.2.2"]
[{"$nulls":4},{"$f":"IF(AND(B43<>\"\",C43<>\"\"),SUM(E43:E51),IF(E68=\"\",\"\",IF(E38=\"\",\"\",IF(E39=\"\",\"\",102500*E67/E68/'Worksheet 1'!I36))))","v":""},null,"6.4.2.2"]
["Calculated percentage loss in metacentric height                                                (GMT) = "]
[]
["2) Second moment of areas used?         ",{"$nulls":5},"6.4.2.1"]
["Second moment of area of free-surface of recess ","SMARECESS",null,"m4",{"$f":"IF(AND(B43<>\"\",C43<>\"\"),\"Calc of different areas\",E79*E81^3/12)","v":0},null,"6.4.2.3"]
["Second moment of area of waterplane of boat at mLA","SMAWP",null,"m4",{"$f":"E36*E37^3/M75","v":0},null,"6.4.2.3",null,"SMAWP = LWL * BWL³ / k",null,null,"where k is between 18 and 24 for motorboats"]
[{"$nulls":4},{"$f":"IF(OR(E36=\"\",E37=\"\"),\"\",IF(AND(B43<>\"\",C43<>\"\"),SUM(F43:F51),IF(E38=\"\",\"\",IF(E39=\"\",\"\",245*E73/E74))))","v":""},null,"6.4.2.3",{"$nulls":4},"k = ",24,"default value 20, please insert exact value from your hydrostatic programm"]
["Calculated percentage loss in metacentric height                                            (GMT) = "]
[{"$nulls":12},"Coefficient","k"]
["3) Recess dimensions used?   ",{"$f":"IF('Worksheet 1'!H7=\"multihull\",\"do NOT use for multihulls\",\"\")","v":""},{"$nulls":4},"6.4.2.1*",{"$nulls":4},"l * b³",1,12,{"$f":"M78/12","v":{"v":0.08333333333333333,"d":"0.083"}}]
["Maximum length of recess at the retention level ",null,"l","m",{"$f":"E38","v":0},null,"6.4.2.4",{"$nulls":5},0.9,{"$f":"1/O79","v":{"v":13.333333333333334,"d":"13.33"}},{"$f":"M79/12","v":0.075},null,null,"b"]
["(see 3.5.11)",{"$nulls":11},0.8,{"v":15,"d":"15.00"},{"$f":"M80/12","v":{"v":0.06666666666666667,"d":"0.067"}}]
["Maximum breadth of recess at the retention level ",null,"b","m",{"$f":"E39","v":0},null,"6.4.2.4",{"$nulls":5},0.7,{"v":17.142857142857146,"d":"17.14"},{"v":0.05833333333333333,"d":"0.058"}]
["(see 3.5.11)",{"$nulls":11},0.6,{"$f":"1/O82","v":{"v":20,"d":"20.00"}},{"v":0.049999999999999996,"d":"0.050"}]
["Calculated percentage loss in metacentric height                                                        (GMT) = ",{"$nulls":3},{"$f":"IF(OR(E79=\"\",E81=\"\"),\"\",IF('Worksheet 1'!I9=\"\",\"\",IF('Worksheet 3'!G11=\"\",\"\",270*(E79*E81^3/'Worksheet 1'!I9/'Worksheet 3'!G11^3)^0.7)))","v":""},null,"6.4.2.4"]
[{"$nulls":8},"* clause 6.4.2.1 excludes method 3 for multihulls",{"$nulls":6},"l"]
[]
["Requirement: from results above, applied design category possible?",{"$nulls":3},{"$f":"IF(E7=\"\",\"\",IF(OR(E83<MAX(E58:F63),E75<MAX(E58:F63),E69<MAX(E58:F63)),\"Yes\",\"Fail\"))","v":"Fail"},null,"6.4.2.1"]
[]
["DIRECT CALCULATION METHOD used? ",{"$nulls":5},"6.4.3"]
["Percentage full of water = 60 – 240 F/LH",{"$nulls":3},{"$f":"IF(E33=\"\",\"\",60-240*MIN(E33:E35)/'Worksheet 1'!$I$9)","v":""},null,"** see below"]
["Wind heeling moment for intended design category ",null,"MW ","N∙m",null,null,"** see below"]
["Crew heeling moment at fGZmax",null,null,"N∙m",null,null,"** see below"]
["Maximum swamped righting moment up to least of fD, fV or 50°",null,null,"N∙m",null,null,"** see below"]
["Required margin of righting moment over heeling moment  ",null,null,"N∙m",{"$f":"IF('Worksheet 1'!D7=\"A\",2*'Worksheet 1'!I36,IF('Worksheet 1'!D7=\"B\",1*'Worksheet 1'!I36,IF('Worksheet 1'!D7=\"C\",0.5*'Worksheet 1'!I36,\"n.a.\")))","v":"n.a."},null,"** see below"]
["Actual margin of righting moment over heeling moment  ",null,null,"N∙m",null,null,"** see below"]
[]
["Applied design category possible?",{"$nulls":3},{"$f":"IF(E7=\"\",\"n.a.\",IF(E7=\"calculation not applicable\",\"n.a.\",IF(B27=\"Yes\",\"n.a.\",IF(L89=\"\",IF(E86=\"Yes\",\"Pass\",\"Fail\"),IF(E94>E93,\"Pass\",\"Fail\")))))","v":"n.a."}]
[]
[]
["** For non-sailing boats, the direct calculation method of ISO 12217-1:2017, 6.5.3 may be used."]
[]
["** For sailing boats, the direct calculation method of ISO 12217-2:2017, 6.3.3 may be used."]

{"sheet":"Worksheet 9","index":9,"n_rows":60,"n_cols":53,"rows_kept":60,"merged":[[0,5,0,6],[2,0,2,3],[4,0,4,3],[9,5,9,6]]}
[{"$nulls":5},"Comments"]
[{"$nulls":6},"Derived values"]
["ISO 12217-3:2017   CALCULATION WORKSHEET No.9    FLOTATION TEST",{"$nulls":5},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["For option 8,9: Are conditions for exemption according to cl.7.4.1 satisfied?"]
[{"$nulls":3},"if yes, please see table below"]
["normative annexes C and D                                    assumed Crew Limit (CL) =",{"$f":"'Worksheet 1'!I17","v":0},{"$nulls":50},"list:"]
[{"$nulls":52},"Yes"]
["Preparation",{"$nulls":51},"No"]
["Item","Unit","Response","Ref."]
["Mass equal to 25% of dry stores and equipment added?",null,null,"C.2 a)",{"$nulls":48},"Inboard"]
["Inboard or outboard engine fitted?",{"$nulls":51},"Outboard"]
["If inboard fitted, correct engine replacement mass fitted?",null,null,"C.2 d)"]
["Assumed outboard engine power?","Kw",{"$f":"'Worksheet 1'!BF45","v":0},"C.2 c)",null,"please insert R42, R 43 on worksheet 1!",{"$nulls":46},"lead"]
["Mass fitted to represent outboard engine, controls, and battery.","kg",{"$f":"'Worksheet 1'!T45","v":0},"Tables C.1 and C.2",{"$nulls":48},"65/35 brass"]
["Portable fuel tanks removed  and/or fixed tanks are filled?",null,null,"C.2 f)",{"$nulls":48},"steel"]
["Cockpit drains open and drain plugs are fitted?",null,null,"C.2 g)",{"$nulls":48},"cast iron"]
["Void compartments which are not air tanks are opened? ",null,null,"C.2 i)",{"$nulls":48},"aluminium"]
["Number of integral air tanks required to be open?",null,null,"Table C.3",{"$nulls":48},"others"]
["Type of test weights used: lead, 65/35 brass, steel, cast iron, aluminum",null,null,"C.3.2",null,"if other materials used, please insert material factor here:",{"$nulls":46},"Pass"]
["Material factor d",null,{"$f":"IF(C22=\"others\",F23,IF(C22=\"lead\",1.099,IF(C22=\"65/35 brass\",1.138,IF(C22=\"steel\",1.151,IF(C22=\"cast iron\",1.163,IF(C22=\"aluminium\",1.612,\"Failure\"))))))","v":"Failure"},"Table C.4",null,null,"material factor d",{"$nulls":45},"Fail"]
[]
["Swamped stability test (for Level flotation):"]
["Item","Unit","Response","Ref.",{"$nulls":48},"preparation completed?"]
["Dry mass of test weights = 6dCL but > 15d","kg",{"$f":"IF(15*C23>6*C23*B9,15*C23,6*B9*C23)","v":{"$error":"#VALUE!"}},"Table C.6"]
["Test weight hung from gunwale each of four positions in turn?",null,null,"C.3.1",{"$nulls":48},{"$f":"IF(COUNTIF(C13:C21,\"Yes\")>=3,\"Yes\",\"No\")","v":"No"}]
["5 min after swamping, boat floats with less than 45° heel?",null,null,"C.3.4 + C.3.5"]
[{"$nulls":52},"persons"]
["Swamped buoyancy test (for Level and Basic flotation):",{"$nulls":51},"weights"]
["Item","Unit","Response","Ref."]
["Load test:",null,null,"C.4"]
["DesignCategory assessed",null,{"$f":"'Worksheet 1'!D7","v":0}]
["Dry mass of test weights used","kg",{"$f":"IF('Worksheet 1'!D7=\"C\",'Worksheet 9'!C23*(60+15*'Worksheet 1'!I17),IF('Worksheet 1'!D7=\"D\",'Worksheet 9'!C23*(50+10*'Worksheet 1'!I17),\"\"))","v":""},"Table C.5"]
["5 min after swamping, boat can be pumped or bailed dry?",null,null,"C.4.3"]
["One Person Test (for Level flotation boats where LH < 4,8m only)",null,null,"C.4"]
["Test weights or actual persons used?"]
["Mass of test weights/persons loaded on inner bottom of boat","kg",null,"Table C.5"]
["5 min after swamping, boat can be pumped or bailed dry?",null,null,"C.4.3"]
[]
["Flotation material and elements"]
["Item",null,"Response","Ref."]
["All flotation elements comply with all requiremnets?  ",null,null,"Table D.1"]
[{"$nulls":26},"Yes"]
["Design Category given: NB: boat must obtain PASS three times in above tables",null,null,{"$f":"IF(OR(C44=\"\",C44=\"Fail\"),\"Fail\",IF(AND('Worksheet 3'!E38=6,COUNTIF(C29:C44,\"PASS\")>=2),'Worksheet 1'!D7,IF(COUNTIF(C29:C44,\"PASS\")>=3,'Worksheet 1'!D7,\"Fail\")))","v":"Fail"},{"$nulls":22},"No"]
[]
[]
[]
[]
["Table check exemptions according to 7.4.1:"]
[]
["Item",null,"Response","Ref."]
["Boat > 4,8m?",null,{"$f":"IF('Worksheet 1'!I9=\"\",\"\",IF('Worksheet 1'!I9>4.8,\"Yes\",\"No\"))","v":""},"7.4.1"]
["mLC > 150 * LH",null,{"$f":"IF(C54=\"\",\"\",IF('Worksheet 1'!I15>150*'Worksheet 1'!I9,\"Yes\",\"No\"))","v":""},"7.4.1"]
["Boat is partially protected according to 3.1.6 ?",null,null,"7.4.1"]
["Boat complies with wind stiffness test of 7.7 (see worksheet 13,13a)",null,null,"7.4.1"]
["Boat satisfied downflooding height requirements of option 4 (LH/12) ?",null,{"$f":"IF('Worksheet 4'!F28=\"\",\"\",IF('Worksheet 4'!F28>'Worksheet 1'!I9/12,\"Yes\",\"No\"))","v":""},"7.4.1"]
[]
["Exempt from level flotation test ?",null,{"$f":"IF(COUNTIF(C54:C58,\"Yes\")=5,\"Yes\",\"No\")","v":"No"},"7.4.1"]

{"sheet":"Worksheet 10","index":10,"n_rows":59,"n_cols":27,"rows_kept":59,"merged":[[0,6,0,7],[2,0,2,4],[4,0,4,4],[9,0,9,4],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[13,0,13,4],[22,0,22,4],[33,0,33,4],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,1],[40,0,40,2],[41,0,41,2],[42,0,42,2],[51,0,51,2],[58,0,58,2]]}
[{"$nulls":6},"Comments"]
[{"$nulls":7},"Derived values"]
["ISO 12217-3:2017   CALCULATION WORKSHEET No.10                     BASIC FLOTATION REQUIREMENT",{"$nulls":6},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["For option 8,9: Are conditions for exemption according to cl.7.4.2 satisfied?"]
[{"$nulls":4},"if yes, please see table below"]
["Normative annex E"]
["Objective: to show that the buoyancy available from the hull structure, fittings and flotation elements equals or exceeds that required to support the boat as loaded for the swamped load test."]
[]
["Item","Mass \n[kg]","Desitiy\n[kg/m³]","Volume\n[m³]","Ref.",{"$nulls":21},"Yes"]
[{"$nulls":26},"No"]
["hull structure:"]
["GRP laminate",null,null,{"$f":"IF(OR(B15=\"\",C15=\"\"),\"\",B15/C15)","v":""},"Table E.1"]
["foam core materials",null,null,{"$f":"IF(OR(B16=\"\",C16=\"\"),\"\",B16/C16)","v":""},"Table E.1"]
["balsa core materials",null,null,"","Table E.1"]
["plywood",null,null,"","Table E.1"]
["other timber (type =      )",null,null,"","Table E.1"]
["permanent ballast (type = )",null,null,"","Table E.1"]
["fastenings and other metalwork (type )",null,null,"","Table E.1"]
["windows ( glass / plastic )",null,null,"","Table E.1"]
["engines and other fittings and equipment:"]
["diesel engine(s)",null,null,"","Table E.1"]
["petrol engine(s)",null,null,"","Table E.1"]
["outboard engine(s)",null,null,"","Table E.1"]
["sail-drive or stern-drive strut(s)",null,null,"","Table E.1"]
["mast(s) and spar(s)   (material = alloy / spruce)",null,null,"","Table E.1"]
["stowed sails and ropes",null,null,"","Table E.1"]
["food and other stores",null,null,"","Table E.1"]
["miscellaneous equipment",null,null,"","Table E.1"]
["non-integral fuel tank(s)  (material =  )",null,null,"","Table E.1"]
["non-integral water tank(s) (material = )",null,null,"","Table E.1"]
["gross volumes of fixed tanks and air containers:"]
["fuel tank(s)",{"$nulls":3},"E.2.2"]
["water tank(s)",{"$nulls":3},"E.2.2"]
["other tank(s)",{"$nulls":3},"E.2.2"]
["air tanks or containers meeting the requirements of normative annex D",{"$nulls":3},"E.2.2"]
["total volume of hull, fittings and equipment                            VB = sum of all above ",null,null,{"$f":"SUM(D15:D22)+SUM(D24:D33)+SUM(D35:D38)","v":{"v":0,"d":"0.000"}},"E.2.2"]
["mass of boat prepared and loaded according to C.2 and C.4.3",null,"mTEST  kg",null,"E.2.3",{"$nulls":21},"Pass"]
["calculate ratio mTEST /VB =",null,null,{"$f":"IF(OR(D39=0,D40=\"\"),\"\",D40/D39)","v":""},"E.2.3",{"$nulls":21},"Fail"]
["for option 8,9     mTEST / VB < 930                                                           Pass / Fail?",null,null,{"$f":"IF(D40=\"\",\"\",IF(D41<930,\"Pass\",\"Fail\"))","v":""},"E.2.3"]
["for option 11      mTEST / VB < 850                                                           Pass / Fail?",null,null,{"$f":"IF(D40=\"\",\"\",IF(D41<850,\"Pass\",\"Fail\"))","v":""},"E.2.3",{"$nulls":21},"Yes"]
[{"$nulls":26},"No"]
["Alternative practical test (for option 11) done ?*",{"$nulls":3},"7.8.1.b"]
[]
["* please send test documentation with photos, videos…."]
[]
[]
["Table check exemptions according to 7.4.2:"]
[]
["Item",null,null,"Response","Ref."]
["Boat > 4,8m?",null,null,{"$f":"IF('Worksheet 1'!I9=\"\",\"\",IF('Worksheet 1'!I9>4.8,\"Yes\",\"No\"))","v":""},"7.4.2"]
["mLC > 150 * LH",null,null,{"$f":"IF(D53=\"\",\"\",IF('Worksheet 1'!I15>150*'Worksheet 1'!I9,\"Yes\",\"No\"))","v":""},"7.4.2"]
["Boat is partially protected according to 3.1.6 ?",{"$nulls":3},"7.4.2"]
["Boat complies with wind stiffness test of 7.7 (see worksheet 13,13a)",{"$nulls":3},"7.4.2"]
["Boat satisfied downflooding height requirements of option 4 (LH/12) ?",null,null,{"$f":"IF('Worksheet 4'!F28=\"\",\"\",IF('Worksheet 4'!F28>'Worksheet 1'!I9/12,\"Yes\",\"No\"))","v":""},"7.4.2"]
[]
["Exempt from basic flotation test ?",null,null,{"$f":"IF(COUNTIF(D53:D57,\"Yes\")=5,\"Yes\",\"No\")","v":"No"},"7.4.2"]

{"sheet":"Worksheet 11","index":11,"n_rows":38,"n_cols":53,"rows_kept":38,"merged":[[0,5,0,6],[2,0,2,3],[4,0,4,4],[6,0,6,4],[7,5,7,6],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,20,0],[19,1,26,4],[21,0,26,0],[27,1,27,4],[28,0,32,4],[33,1,33,2],[33,3,33,4],[34,1,34,2],[35,1,35,2],[37,1,37,2]]}
[{"$nulls":5},"Comments"]
[{"$nulls":6},"Derived values"]
["ISO 12217-3:2017   CALCULATION WORKSHEET No.11    CAPSIZE RECOVERY TEST",{"$nulls":5},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Objective: to demonstrate that a boat can be returned to the upright after a capsize by the actions of the crew using their body action and/or righting devices purposely designed and permanently fitted to the boat, that it will subsequently float, and to verify that the recommended minimum crew mass is sufficient for the recovery method used.",{"$nulls":51},"list:"]
[{"$nulls":52},"Yes"]
[{"$nulls":52},"No"]
["Item",null,"Unit","Value","Ref."]
["Minimum number of crew required",null,"—",null,"6.9.5",{"$nulls":47},"C"]
["Minimum mass of crew required",null,"kg",null,"6.9.5",{"$nulls":47},"D"]
["Boat prepared as in 6.9.2 to 6.9.4 ?",null,"YES / NO?",null,"6.9.2 to 6.9.4"]
["Does boat float for more than 5 min when fully capsized",null,"YES / NO?",null,"6.9.4",{"$nulls":47},"Pass"]
["Time required to right the boat (least time of 1 to 3 attempts)",null,"min",null,"6.9.6",{"$nulls":47},"Fail"]
["Is this time less than 5 min",null,"YES / NO?",null,"6.9.6"]
["With one 75 kg person aboard, boat floats so it can be pumped or bailed out",null,"YES / NO?",null,"6.9.8"]
["With full Crew Limit aboard, without bailing, boat floats approx. level with at\nleast 2/3 periphery showing, for more than 5 min",null,"YES / NO?",null,"6.9.9"]
["Safety signs are displayed?",null,"YES / NO?",null,"6.9.10"]
["INFORMATION FOR OWNER’S MANUAL:\nlikelihood of capsize occurring in normal use:"]
{"$rows_empty":7}
["Righting technique which is most successful:"]
[]
[]
[]
[]
[]
["Minimum number of crew required:",null,null,"persons"]
["Minimum mass of crew required:",null,null,"kg"]
["Design Category recommended by the builder:"]
[]
["All requirements met?"]

{"sheet":"Worksheet 12","index":12,"n_rows":27,"n_cols":53,"rows_kept":27,"merged":[[0,5,0,6],[2,0,2,3],[4,0,4,4],[6,0,6,4],[7,5,7,6],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[12,2,12,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[20,0,20,1],[21,0,21,1],[22,0,22,1]]}
[{"$nulls":5},"Comments"]
[{"$nulls":6},"Derived values"]
["ISO 12217-3:2017   CALCULATION WORKSHEET No.12    KNOCKDOWN RECOVERY TEST",{"$nulls":5},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
[{"$nulls":52},"list:"]
[{"$nulls":52},"Yes"]
["Experimental method:",{"$nulls":47},"persons",{"$nulls":3},"No"]
["Item",null,"Cat. C","Cat. D","Ref.",{"$nulls":4},"Test used?",{"$nulls":38},"water"]
["Crew limit",null,{"$f":"IF('Worksheet 1'!D7=\"C\",'Worksheet 1'!I17,\"\")","v":""},{"$f":"IF('Worksheet 1'!D7=\"D\",'Worksheet 1'!I17,\"\")","v":""},"3.4.2",{"$nulls":4},{"$f":"IF(OR('Worksheet 3'!E38=8,'Worksheet 3'!E38=10),\"Yes\",\"n.a.\")","v":"n.a."},{"$nulls":38},"other weights",{"$nulls":3},"C"]
["Boat prepared and persons positioned as in 7.6.2 and figure 11 ?",{"$nulls":3},"7.6.2",{"$nulls":4},"pass cat C conditions(pract. or theor.)?",{"$nulls":42},"D"]
["Addition of persons, water or other test weights to a total mass not less than that of the crew limit?",{"$nulls":3},"7.6.2",{"$nulls":4},{"$f":"IF('Worksheet 1'!D7<>\"C\",\"n.a.\",IF(OR(C18=\"Pass\",C23=\"Pass\"),\"Pass\",\"Fail\"))","v":"n.a."}]
["Masthead taken to   ",null,"waterline","horizontal","7.6.3 / 7.6.4",{"$nulls":4},"pass cat D conditions(pract. or theor.)?",{"$nulls":42},"Pass"]
["Masthead held in position for",null,"60 s","10 s","7.6.3 / 7.6.4",{"$nulls":4},{"$f":"IF('Worksheet 1'!D7<>\"D\",\"n.a.\",IF(OR(D18=\"Pass\",D23=\"D\"),\"Pass\",\"Fail\"))","v":"n.a."},{"$nulls":42},"Fail"]
["Boat recovers when released?",{"$nulls":3},"7.6.3 / 7.6.4"]
["Boat floats so it can be pumped or bailed out?",{"$nulls":3},"7.6.3 / 7.6.4"]
["If boat achieves 'Yes' to each of above, design category is ok   ",null,{"$f":"IF(C12=\"\",\"\",IF(COUNTIF(C12:C17,\"Yes\")=3,\"Pass\",\"Fail\"))","v":""},{"$f":"IF(D12=\"\",\"\",IF(COUNTIF(D12:D17,\"Yes\")=3,\"Pass\",\"Fail\"))","v":""}]
[]
["Alternative theoretical method:"]
["Item",null,"Cat. C","Cat. D","Ref."]
["Is GZ positive at heel angle defined above?",{"$nulls":3},"7.6.5",null,"clause 7.6.5:"]
["Design category given:",null,{"$f":"IF(C22=\"\",\"\",IF(C22=\"Yes\",\"C\",\"Fail\"))","v":""},{"$f":"IF(D22=\"\",\"\",IF(D22=\"Yes\",\"D\",\"Fail\"))","v":""},null,null,"Calculation to show that the righting moment is positive at the initial angle of heel* may be used"]
[{"$nulls":6},"instead of a practical test, provided it is assumed that the main access hatchway to cabins is fully open,"]
[{"$nulls":6},"and that water enters any spaces subject to downflooding."]
[]
[{"$nulls":6},"* to waterline or horizontal"]

{"sheet":"Worksheet 13","index":13,"n_rows":45,"n_cols":52,"rows_kept":45,"merged":[[0,8,0,9],[2,0,2,6],[4,0,4,6],[8,0,8,1],[8,2,8,6],[9,2,9,6],[10,0,10,1],[11,0,11,6],[12,0,12,1],[12,12,12,14],[13,0,13,2],[13,4,13,5],[14,0,14,1],[14,4,14,5],[15,0,15,1],[15,4,15,5],[16,0,16,1],[16,4,16,5],[17,0,17,1],[17,4,17,5],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,2],[21,4,21,5],[22,0,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[25,0,25,6],[27,0,27,1],[28,0,28,6],[29,0,29,1],[30,0,30,2],[30,4,30,5],[31,0,31,2],[31,4,31,5],[32,0,32,2],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,2],[40,0,40,2],[40,4,40,5],[41,0,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[44,0,44,6]]}
[{"$nulls":8},"Comments"]
[{"$nulls":9},"Derived values"]
["ISO 12217-3:2017  CALCULATION WORKSHEET No. 13                        WINDSTIFFNESS TEST",{"$nulls":8},"Input values"]
[{"$nulls":30},"list"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "},{"$nulls":29},"Yes",5,"C"]
[{"$nulls":30},"No",6,"D"]
[{"$nulls":6},"Design Cat. C and D using option 9 or cat D using option 11 only"]
[{"$nulls":30},"Experimental"]
["Method used:",{"$nulls":29},"Theoretical"]
[null,null,{"$f":"IF('Worksheet 1'!I11<=300,\"option not possible for boats with mEC <= 300kg\",\"\")","v":"option not possible for boats with mEC <= 300kg"}]
["Experimental method:"]
[]
["Item",null,"Symbol","Unit","Un-reefed","Reefed","Ref.",{"$nulls":5},"req. wind speed in metres per second"]
["Boat prepared and weight positioned as in 7.7.2.1?",null,null,"Yes / No",null,null,"7.7.2.1",{"$nulls":5},"Design category","C","D"]
["Final tension in pull-down line",null,"T","kg",null,null,"7.7.2.3",{"$nulls":6},11,6]
["Perpendicular lever between pull-down and mooring lines (see fig. 12)",null,"h","m",null,null,"7.7.2.3"]
["Final angle of heel observed",null,"ΦT","degree",null,null,"7.7.2.3"]
["Beam of hull",null,"BH","m",{"$f":"'Worksheet 3'!G11","v":{"v":0,"d":"0.00"}},null,"4. Table 1"]
["Actual profile projected area of sails, including overlaps ",null,"A'S","m²",null,null,"7.7.2.4"]
["Upright lever from centre of sail area to underwater profile (see fig. 13)",null,"hCE + hLP","m",null,null,"7.7.2.4"]
["Calculated wind speed = ",null,"vW","m/s",{"$f":"SQRT((13*E16*E15+390*E18)/E19/E20/(COS(RADIANS(E17)))^1.3)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((13*E16*E15+390*E18)/F19/F20/(COS(RADIANS(E17)))^1.3)","v":{"$error":"#DIV/0!"}},"7.7.2.4"]
["Is reefed sail plan used?                                ",null,null,"Yes / No",null,null,"7.7.4.2"]
["Design Category given:",{"$nulls":3},{"$f":"IF(E22=\"Yes\",\"/\",IF(E22=\"No\",IF(E21>=11,\"C\",IF(E21>=6,\"D\",\"Fail\"))))","v":false},{"$f":"IF(E22=\"No\",\"/\",IF(E22=\"Yes\",IF(F21>=11,\"C\",IF(F21>=6,\"D\",\"Fail\"))))","v":false},"7.7.4.1",{"$nulls":5},{"$f":"IF(C9=\"\",\"\",IF(C9=\"Experimental\",IF(OR(E23=\"C\",F23=\"C\"),\"Pass\",\"Fail\")))","v":""},null,null,{"$f":"IF('Worksheet 1'!D7=\"C\",'Worksheet 13'!M23,'Worksheet 13'!M24)","v":""},{"$nulls":10},{"$f":"IF(C9=\"Experimental\",IF(OR(E23=\"Fail\",F23=\"Fail\"),\"Fail\",\"Pass\"),IF(C9=\"\",\"\",IF(OR(E42=\"Fail\",F42=\"Fail\"),\"Fail\",\"Pass\")))","v":""},{"$nulls":24},"sAbfragetabelle"]
[{"$nulls":12},{"$f":"IF(C9=\"\",\"\",IF(C9=\"Experimental\",IF(OR(E23=\"C\",E23=\"D\",F23=\"C\",F23=\"D\"),\"Pass\",\"Fail\")))","v":""}]
[]
["NB: Safety signs in accordance with Figure 14 must be affixed to the boat."]
[]
["Alternative theoretical method:"]
[]
["Item",null,"Symbol","Unit","Un-reefed","Reefed","Ref."]
["Righting moment curve increased by one crew to windward",{"$nulls":3},"Yes",null,"7.7.3.2",null,"see worksheet 13a"]
["Option (from worksheet 3) being used",{"$nulls":3},{"$f":"'Worksheet 3'!E38","v":0},null,"Table 7"]
["Design Category intended",{"$nulls":3},{"$f":"'Worksheet 1'!D7","v":{"v":0,"d":"0.00"}},{"$f":"'Worksheet 1'!D7","v":{"v":0,"d":"0.00"}},"9.2"]
["Relevant wind speed",null,"vW","m/s",11,6,"7.7.4.1"]
["Actual profile projected area of sails, including overlaps ",null,"A'S","m²",null,null,"7.7.2.4"]
["Upright lever from centre of sail area to underwater profile (see fig. 13)",null,"hCE + hLP","m",null,null,"7.7.2.4"]
["Calculated 0,75 vW2 A'S (h'CE hLP)",null,"MW0","Nm",{"$f":"0.75*E34^2*E35*E36","v":0},{"$f":"0.75*F34^2*F35*F36","v":0},"7.7.3.3"]
["From righting moment curve augmented by 294 BH cosΦ and wind heeling curve [= M W0 (cosΦ)1,3] resulting angle of heel =",null,"Φ","degree",{"$f":"IF('Worksheet 13a'!$B$10=\"unreefed\",'Worksheet 13a'!$B$66,\"\")","v":""},{"$f":"IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13a'!$B$66,\"\")","v":""},"7.7.3.4"]
["Downflooding angle",null,"ΦD","degree",null,null,"7.7.3.4"]
["Is Φ < ΦD  and < 45°?                                            ",null,null,"Yes / No",{"$f":"IF(E38=\"\",\"\",IF(AND(E38<E39,E38<45),\"Yes\",\"Fail\"))","v":""},{"$f":"IF(F38=\"\",\"\",IF(AND(F38<F39,F38<45),\"Yes\",\"Fail\"))","v":""},"7.7.3.4"]
["Is reefed sail plan used?                                ",null,null,"Yes / No",{"$f":"IF('Worksheet 13a'!B10=\"reefed\",\"Yes\",IF('Worksheet 13a'!B10=\"\",\"\",\"No\"))","v":""},null,"7.7.4.2"]
["Design Category given:",{"$nulls":3},{"$f":"IF(E40=\"yes\",E33,IF(E41=\"Yes\",\"Check reefed sails\",\"Fail\"))","v":"Fail"},{"$f":"IF(E41=\"no\",\"\",IF(F40=\"Yes\",F33,\"Fail\"))","v":"Fail"}]
[{"$nulls":12},{"$f":"IF(OR(E42=E33,F42=F33),\"Pass\",\"Fail\")","v":"Fail"}]
[]
["NB: Safety signs in accordance with Figure 14 must be affixed to the boat.",{"$nulls":11},{"$f":"IF(OR(E22=\"yes\",E41=\"yes\"),\"reefed\",\"unreefed\")","v":"unreefed"}]

{"sheet":"Worksheet 13a","index":14,"n_rows":112,"n_cols":64,"rows_kept":112,"merged":[[0,13,0,14],[1,0,1,7],[3,0,3,7],[5,4,6,7]]}
[{"$nulls":13},"Comments"]
["ISO 12217-2:2017   CALCULATION WORKSHEET No. 9a                     curve of righting moment vs. wind heeling curve",{"$nulls":13},"Derived values"]
[{"$nulls":14},"Input values",{"$nulls":32},"list:"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[{"$nulls":47},"wind heeling moment curve"]
["insert curve of righting moment in 5° steps in one of following units:",{"$nulls":3},"curve of righting moments when loaded with one crew member at the centerline (mLC + 75kg)",{"$nulls":42},"unreefed"]
[null,"N m","kg m","m",{"$nulls":43},"reefed"]
[]
[null,null,"chosen unit"]
[null,null,"chose if reefed or unreefed sail combination used"]
["heeling angle[°]","insert righting \nArm   / Moment \n[Nm, kg m, m]","Righting Moment\n[Nm]","Righting Moment \n[kg m]","Righting Arm Gz \n[m]","Diff(B-A/5)","Wind Heeling moment curve\n [N m]","Righting moment curve increased by one crew windward",{"$nulls":45},"Righting moment curve increased by one crew windward","Crew Heeling moment curve\n [N m]","check",null,null,"calc",null,"nachkomma","Righting Moment [Nm]","Crew Heeling moment curve\n [N m]","check"]
[0,null,{"$f":"D12*9.806","v":{"$error":"#VALUE!"}},{"$f":"E12*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B12/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B12/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B12,\"error\")))","v":"error"},{"$f":"(E17-E12)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A12)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A12)),\"error\"))","v":"error"},{"$f":"C12+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A12))","v":{"$error":"#VALUE!"}},{"$nulls":44},0,{"$f":"H12","v":{"$error":"#VALUE!"}},{"$f":"G12","v":"error"},{"$f":"IF(AND(BB11<BC11,BB12>BC12),1,\"\")","v":{"$error":"#VALUE!"}},null,null,"Vorkomma",null,{"$f":"BG13","v":{"$error":"#N/A"}},{"$f":"BG19","v":{"$error":"#N/A"}},{"$f":"BG25","v":{"$error":"#N/A"}},{"$f":"IF(AND(BJ11<BK11,BJ12>BK12),1,\"\")","v":{"$error":"#N/A"}}]
[1,null,{"$error":"#VALUE!"},{"$f":"E13*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E12+F12","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A13)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A13)),\"error\"))","v":"error"},{"$f":"C13+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A13))","v":{"$error":"#VALUE!"}},{"$nulls":44},1,{"$f":"H13","v":{"$error":"#VALUE!"}},{"$f":"G13","v":"error"},{"$f":"IF(AND(BB12<BC12,BB13>BC13),1,\"\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"LOOKUP(1,BD12:BD62,BA12:BA62-1)","v":{"$error":"#N/A"}},null,{"$f":"BI12+0.01","v":{"$error":"#N/A"}},{"$f":"BJ12+$BG$23","v":{"$error":"#N/A"}},{"$f":"BK12+$BG$29","v":{"$error":"#N/A"}},{"$f":"IF(AND(BJ12<BK12,BJ13>BK13),1,\"\")","v":{"$error":"#N/A"}}]
[2,null,{"$error":"#VALUE!"},{"$f":"E14*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E13+F12","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A14)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A14)),\"error\"))","v":"error"},{"$f":"C14+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A14))","v":{"$error":"#VALUE!"}},{"$nulls":44},2,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,"Genau",null,{"$f":"BI13+0.01","v":{"$error":"#N/A"}},{"$f":"BJ13+$BG$23","v":{"$error":"#N/A"}},{"$f":"BK13+$BG$29","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[3,null,{"$error":"#VALUE!"},{"$f":"E15*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E14+F12","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A15)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A15)),\"error\"))","v":"error"},{"$f":"C15+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A15))","v":{"$error":"#VALUE!"}},{"$nulls":44},3,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,{"$f":"IF(B12=\"\",\"\",LOOKUP(1,BL12:BL112,BI12:BI112))","v":""},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,null,{"$error":"#VALUE!"},{"$f":"E16*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E15+F12","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A16)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A16)),\"error\"))","v":"error"},{"$f":"C16+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A16))","v":{"$error":"#VALUE!"}},{"$nulls":44},4,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,null,{"$error":"#VALUE!"},{"$f":"E17*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B17/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B17/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B17,\"error\")))","v":"error"},{"$f":"(E22-E17)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A17)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A17)),\"error\"))","v":"error"},{"$f":"C17+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A17))","v":{"$error":"#VALUE!"}},{"$nulls":44},5,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,null,{"$error":"#VALUE!"},{"$f":"E18*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E17+F17","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A18)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A18)),\"error\"))","v":"error"},{"$f":"C18+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A18))","v":{"$error":"#VALUE!"}},{"$nulls":44},6,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,"Nachbestimmung",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,null,{"$error":"#VALUE!"},{"$f":"E19*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E18+F17","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A19)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A19)),\"error\"))","v":"error"},{"$f":"C19+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A19))","v":{"$error":"#VALUE!"}},{"$nulls":44},7,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,"Righting",{"$f":"LOOKUP(BG13,BA12:BA62,BB12:BB62)","v":{"$error":"#N/A"}},"untere ",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,null,{"$error":"#VALUE!"},{"$f":"E20*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E19+F17","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A20)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A20)),\"error\"))","v":"error"},{"$f":"C20+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A20))","v":{"$error":"#VALUE!"}},{"$nulls":44},8,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,"Moment",{"$f":"LOOKUP(BG13+1,BA12:BA62,BB12:BB62)","v":{"$error":"#N/A"}},"obere",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,null,{"$error":"#VALUE!"},{"$f":"E21*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E20+F17","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A21)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A21)),\"error\"))","v":"error"},{"$f":"C21+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A21))","v":{"$error":"#VALUE!"}},{"$nulls":44},9,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,null,{"$error":"#VALUE!"},{"$f":"E22*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B22/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B22/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B22,\"error\")))","v":"error"},{"$f":"(E27-E22)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A22)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A22)),\"error\"))","v":"error"},{"$f":"C22+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A22))","v":{"$error":"#VALUE!"}},{"$nulls":5},"Please insert unit of righting moment curve in B9!",{"$nulls":38},10,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,{"$f":"BG20-BG19","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,null,{"$error":"#VALUE!"},{"$f":"E23*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E22+F22","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A23)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A23)),\"error\"))","v":"error"},{"$f":"C23+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A23))","v":{"$error":"#VALUE!"}},{"$nulls":44},11,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,{"$f":"BG22/100","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,null,{"$error":"#VALUE!"},{"$f":"E24*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E23+F22","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A24)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A24)),\"error\"))","v":"error"},{"$f":"C24+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A24))","v":{"$error":"#VALUE!"}},{"$nulls":44},12,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,null,{"$error":"#VALUE!"},{"$f":"E25*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E24+F22","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A25)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A25)),\"error\"))","v":"error"},{"$f":"C25+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A25))","v":{"$error":"#VALUE!"}},{"$nulls":44},13,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,"Crew",{"$f":"LOOKUP(BG13,BA12:BA62,BC12:BC62)","v":{"$error":"#N/A"}},"untere ",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,null,{"$error":"#VALUE!"},{"$f":"E26*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E25+F22","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A26)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A26)),\"error\"))","v":"error"},{"$f":"C26+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A26))","v":{"$error":"#VALUE!"}},{"$nulls":44},14,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,"Moment",{"$f":"LOOKUP(BG13+1,BA12:BA62,BC12:BC62)","v":{"$error":"#N/A"}},"obere",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,null,{"$error":"#VALUE!"},{"$f":"E27*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B27/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B27/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B27,\"error\")))","v":"error"},{"$f":"(E32-E27)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A27)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A27)),\"error\"))","v":"error"},{"$f":"C27+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A27))","v":{"$error":"#VALUE!"}},{"$nulls":44},15,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,null,{"$error":"#VALUE!"},{"$f":"E28*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E27+F27","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A28)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A28)),\"error\"))","v":"error"},{"$f":"C28+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A28))","v":{"$error":"#VALUE!"}},{"$nulls":44},16,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,{"$f":"BG26-BG25","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[17,null,{"$error":"#VALUE!"},{"$f":"E29*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E28+F27","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A29)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A29)),\"error\"))","v":"error"},{"$f":"C29+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A29))","v":{"$error":"#VALUE!"}},{"$nulls":44},17,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},null,null,{"$f":"BG28/100","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[18,null,{"$error":"#VALUE!"},{"$f":"E30*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E29+F27","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A30)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A30)),\"error\"))","v":"error"},{"$f":"C30+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A30))","v":{"$error":"#VALUE!"}},{"$nulls":44},18,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,null,{"$error":"#VALUE!"},{"$f":"E31*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E30+F27","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A31)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A31)),\"error\"))","v":"error"},{"$f":"C31+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A31))","v":{"$error":"#VALUE!"}},{"$nulls":44},19,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[20,null,{"$error":"#VALUE!"},{"$f":"E32*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B32/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B32/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B32,\"error\")))","v":"error"},{"$f":"(E37-E32)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A32)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A32)),\"error\"))","v":"error"},{"$f":"C32+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A32))","v":{"$error":"#VALUE!"}},{"$nulls":44},20,{"$error":"#VALUE!"},"error",{"$f":"IF(AND(BB31<BC31,BB32>BC32),1,\"\")","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[21,null,{"$error":"#VALUE!"},{"$f":"E33*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E32+F32","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A33)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A33)),\"error\"))","v":"error"},{"$f":"C33+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A33))","v":{"$error":"#VALUE!"}},{"$nulls":44},21,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[22,null,{"$error":"#VALUE!"},{"$f":"E34*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E33+F32","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A34)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A34)),\"error\"))","v":"error"},{"$f":"C34+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A34))","v":{"$error":"#VALUE!"}},{"$nulls":44},22,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[23,null,{"$error":"#VALUE!"},{"$f":"E35*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E34+F32","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A35)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A35)),\"error\"))","v":"error"},{"$f":"C35+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A35))","v":{"$error":"#VALUE!"}},{"$nulls":44},23,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[24,null,{"$error":"#VALUE!"},{"$f":"E36*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E35+F32","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A36)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A36)),\"error\"))","v":"error"},{"$f":"C36+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A36))","v":{"$error":"#VALUE!"}},{"$nulls":44},24,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[25,null,{"$error":"#VALUE!"},{"$f":"E37*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B37/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B37/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B37,\"error\")))","v":"error"},{"$f":"(E42-E37)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A37)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A37)),\"error\"))","v":"error"},{"$f":"C37+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A37))","v":{"$error":"#VALUE!"}},{"$nulls":44},25,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[26,null,{"$error":"#VALUE!"},{"$f":"E38*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E37+F37","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A38)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A38)),\"error\"))","v":"error"},{"$f":"C38+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A38))","v":{"$error":"#VALUE!"}},{"$nulls":44},26,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[27,null,{"$error":"#VALUE!"},{"$f":"E39*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E38+F37","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A39)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A39)),\"error\"))","v":"error"},{"$f":"C39+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A39))","v":{"$error":"#VALUE!"}},{"$nulls":44},27,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[28,null,{"$error":"#VALUE!"},{"$f":"E40*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E39+F37","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A40)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A40)),\"error\"))","v":"error"},{"$f":"C40+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A40))","v":{"$error":"#VALUE!"}},{"$nulls":44},28,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[29,null,{"$error":"#VALUE!"},{"$f":"E41*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E40+F37","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A41)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A41)),\"error\"))","v":"error"},{"$f":"C41+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A41))","v":{"$error":"#VALUE!"}},{"$nulls":44},29,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[30,null,{"$error":"#VALUE!"},{"$f":"E42*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B42/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B42/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B42,\"error\")))","v":"error"},{"$f":"(E47-E42)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A42)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A42)),\"error\"))","v":"error"},{"$f":"C42+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A42))","v":{"$error":"#VALUE!"}},{"$nulls":44},30,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[31,null,{"$error":"#VALUE!"},{"$f":"E43*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E42+F42","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A43)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A43)),\"error\"))","v":"error"},{"$f":"C43+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A43))","v":{"$error":"#VALUE!"}},{"$nulls":44},31,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[32,null,{"$error":"#VALUE!"},{"$f":"E44*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E43+F42","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A44)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A44)),\"error\"))","v":"error"},{"$f":"C44+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A44))","v":{"$error":"#VALUE!"}},{"$nulls":44},32,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[33,null,{"$error":"#VALUE!"},{"$f":"E45*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E44+F42","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A45)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A45)),\"error\"))","v":"error"},{"$f":"C45+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A45))","v":{"$error":"#VALUE!"}},{"$nulls":44},33,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[34,null,{"$error":"#VALUE!"},{"$f":"E46*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E45+F42","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A46)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A46)),\"error\"))","v":"error"},{"$f":"C46+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A46))","v":{"$error":"#VALUE!"}},{"$nulls":44},34,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[35,null,{"$error":"#VALUE!"},{"$f":"E47*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B47/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B47/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B47,\"error\")))","v":"error"},{"$f":"(E52-E47)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A47)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A47)),\"error\"))","v":"error"},{"$f":"C47+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A47))","v":{"$error":"#VALUE!"}},{"$nulls":44},35,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[36,null,{"$error":"#VALUE!"},{"$f":"E48*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E47+F47","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A48)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A48)),\"error\"))","v":"error"},{"$f":"C48+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A48))","v":{"$error":"#VALUE!"}},{"$nulls":44},36,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[37,null,{"$error":"#VALUE!"},{"$f":"E49*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E48+F47","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A49)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A49)),\"error\"))","v":"error"},{"$f":"C49+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A49))","v":{"$error":"#VALUE!"}},{"$nulls":44},37,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[38,null,{"$error":"#VALUE!"},{"$f":"E50*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E49+F47","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A50)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A50)),\"error\"))","v":"error"},{"$f":"C50+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A50))","v":{"$error":"#VALUE!"}},{"$nulls":44},38,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[39,null,{"$error":"#VALUE!"},{"$f":"E51*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E50+F47","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A51)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A51)),\"error\"))","v":"error"},{"$f":"C51+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A51))","v":{"$error":"#VALUE!"}},{"$nulls":44},39,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[40,null,{"$error":"#VALUE!"},{"$f":"E52*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B52/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B52/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B52,\"error\")))","v":"error"},{"$f":"(E57-E52)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A52)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A52)),\"error\"))","v":"error"},{"$f":"C52+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A52))","v":{"$error":"#VALUE!"}},{"$nulls":44},40,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[41,null,{"$error":"#VALUE!"},{"$f":"E53*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E52+F52","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A53)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A53)),\"error\"))","v":"error"},{"$f":"C53+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A53))","v":{"$error":"#VALUE!"}},{"$nulls":44},41,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[42,null,{"$error":"#VALUE!"},{"$f":"E54*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E53+F52","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A54)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A54)),\"error\"))","v":"error"},{"$f":"C54+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A54))","v":{"$error":"#VALUE!"}},{"$nulls":44},42,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[43,null,{"$error":"#VALUE!"},{"$f":"E55*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E54+F52","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A55)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A55)),\"error\"))","v":"error"},{"$f":"C55+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A55))","v":{"$error":"#VALUE!"}},{"$nulls":44},43,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[44,null,{"$error":"#VALUE!"},{"$f":"E56*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E55+F52","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A56)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A56)),\"error\"))","v":"error"},{"$f":"C56+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A56))","v":{"$error":"#VALUE!"}},{"$nulls":44},44,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[45,null,{"$error":"#VALUE!"},{"$f":"E57*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B57/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B57/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B57,\"error\")))","v":"error"},{"$f":"(E62-E57)/5","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A57)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A57)),\"error\"))","v":"error"},{"$f":"C57+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A57))","v":{"$error":"#VALUE!"}},{"$nulls":44},45,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[46,null,{"$error":"#VALUE!"},{"$f":"E58*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E57+F57","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A58)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A58)),\"error\"))","v":"error"},{"$f":"C58+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A58))","v":{"$error":"#VALUE!"}},{"$nulls":44},46,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[47,null,{"$error":"#VALUE!"},{"$f":"E59*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E58+F57","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A59)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A59)),\"error\"))","v":"error"},{"$f":"C59+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A59))","v":{"$error":"#VALUE!"}},{"$nulls":44},47,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[48,null,{"$error":"#VALUE!"},{"$f":"E60*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E59+F57","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A60)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A60)),\"error\"))","v":"error"},{"$f":"C60+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A60))","v":{"$error":"#VALUE!"}},{"$nulls":44},48,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[49,null,{"$error":"#VALUE!"},{"$f":"E61*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"E60+F57","v":{"$error":"#VALUE!"}},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A61)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A61)),\"error\"))","v":"error"},{"$f":"C61+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A61))","v":{"$error":"#VALUE!"}},{"$nulls":44},49,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[50,null,{"$error":"#VALUE!"},{"$f":"E62*('Worksheet 1'!$I$15+75)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$9=\"N m\",B62/9.806/('Worksheet 1'!$I$15+75),IF($B$9=\"kg m\",B62/('Worksheet 1'!$I$15+75),IF($B$9=\"m\",B62,\"error\")))","v":"error"},null,{"$f":"IF($B$10=\"unreefed\",'Worksheet 13'!$E$37*COS(RADIANS('Worksheet 13a'!A62)),IF('Worksheet 13a'!$B$10=\"reefed\",'Worksheet 13'!$F$37*COS(RADIANS('Worksheet 13a'!A62)),\"error\"))","v":"error"},{"$f":"C62+294*'Worksheet 3'!$G$11*COS(RADIANS('Worksheet 13a'!A62))","v":{"$error":"#VALUE!"}},{"$nulls":44},50,{"$error":"#VALUE!"},"error",{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"point of intersection of righting moment curve and wind heeling moment curve",{"$nulls":58},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ΦC",{"$nulls":58},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"v":10,"d":"10.00"},"degree","=BG15",{"$nulls":56},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(BJ76<BK76,BJ77>BK77),1,\"\")","v":{"$error":"#N/A"}}]
[{"$nulls":60},{"$f":"BI77+0.01","v":{"$error":"#N/A"}},{"$f":"BJ77+$BG$23","v":{"$error":"#N/A"}},{"$f":"BK77+$BG$29","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":60},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Worksheet 14","index":15,"n_rows":17,"n_cols":53,"rows_kept":17,"merged":[[0,10,0,11],[0,13,0,14],[2,0,2,8],[4,0,4,8],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6]]}
[{"$nulls":10},"Comments"]
[{"$nulls":11},"Derived values"]
["ISO 12217-3:2017 CALCULATION WORKSHEET No. 14      DETECTION + REMOVAL OF WATER",{"$nulls":10},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
[{"$nulls":52},"list:"]
["Item",{"$nulls":6},"Response","Ref.",{"$nulls":43},"Yes"]
["The internal arrangement facilitates the drainage of water to bilge suction point(s), to a location from which it can be bailed rapidly, or directly overboard?                                      ",{"$nulls":7},"6.10.1",{"$nulls":43},"No"]
["Is boat provided with a means of removing water from the bilges in accordance with ISO 15083?",{"$nulls":7},"6.10.2"]
["Table 2 option used for assessment:",{"$nulls":7},"6.10.3"]
["Can water in boat be detected from helm position?",{"$nulls":7},"6.10.3"]
["Methods used:                                                                                      direct visual inspection",{"$nulls":7},"6.10.3"]
["                                                                                                   transparent inspection panels",{"$nulls":7},"6.10.3"]
["                                                                                                                            bilge alarms",{"$nulls":7},"6.10.3"]
["                                                                   indication of the operation of automatic bilge pumps",{"$nulls":7},"6.10.3"]
["other means (specify):",{"$nulls":7},"6.10.3"]

{"sheet":"Worksheet 15","index":16,"n_rows":53,"n_cols":54,"rows_kept":53,"merged":[[0,15,0,16],[1,1,1,10],[1,12,1,13],[3,3,3,5],[6,2,6,6],[6,8,6,9],[7,1,16,1],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,2,13,9],[14,8,14,9],[15,8,15,9],[16,7,16,8],[17,5,17,6],[17,8,17,9],[18,5,18,7],[18,8,18,9],[19,1,23,1],[19,4,19,8],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,2,24,7],[24,8,24,9],[25,1,26,1],[25,5,25,9],[26,5,26,6],[26,8,26,9],[27,1,32,1],[27,2,27,7],[27,8,27,9],[28,2,28,9],[29,2,29,7],[29,8,29,9],[30,2,30,7],[30,8,30,9],[31,2,31,7],[31,8,31,9],[32,2,32,7],[32,8,32,9],[33,8,33,9],[34,1,35,1],[34,2,34,7],[34,8,34,9],[34,10,35,10],[35,2,35,7],[35,8,35,9],[36,1,37,1],[36,2,36,9],[36,10,37,10],[37,2,37,7],[37,8,37,9],[38,1,39,1],[38,2,38,9],[38,10,39,10],[39,2,39,7],[39,8,39,9],[40,2,40,7],[40,8,40,9],[41,1,43,10],[44,1,44,2],[44,5,44,10]]}
[]
[null,"ISO 12217-3:2017 Sailing under 6 m en250115   CALCULATION WORKSHEET No.15         SUMMARY",{"$nulls":10},"Comments"]
[{"$nulls":13},"Derived values"]
[null,"Design Description:",null,{"$f":"coverSheet!B12","v":0},{"$nulls":9},"Input values"]
[null,"Design Category intended:      ",null,{"$f":"'Worksheet 1'!D7","v":0},"Crew Limit: ",{"$f":"'Worksheet 1'!I17","v":0},"Date: ",{"$f":"TODAY()","v":"2025-01-06"}]
[]
[null,"Sheet","Item",{"$nulls":4},"Symbol","Unit",null,"Value"]
[null,1,"Length of hull: (as in ISO 8666)",{"$nulls":4},"LH","m",null,{"$f":"'Worksheet 1'!I9","v":{"v":0,"d":"0.00"}}]
[null,null,"Length of waterline in loaded arrival condition",{"$nulls":4},"LWL","m",null,{"$f":"'Worksheet 1'!I10","v":{"v":0,"d":"0.00"}}]
[null,null,"Beam of hull: (as in ISO 8666)",{"$nulls":4},"BH","m",null,{"$f":"'Worksheet 3'!G11","v":{"v":0,"d":"0.00"}}]
[null,null,"Empty craft condition mass",{"$nulls":4},"mEC","kg",null,{"$f":"'Worksheet 1'!I11","v":0}]
[null,null,"Maximum load",{"$nulls":4},"mL","kg",null,{"$f":"'Worksheet 1'!I33","v":0}]
[null,null,"Maximum load for the builder's plate acc to ISO 14946:2021",{"$nulls":4},"mMBP","kg",null,{"$f":"'Worksheet 1'!I37","v":0},null,"if manually reduced on worksheet 1b, the reduced value is shown"]
[null,null,"Number of portable tanks included in max. load for the builder's plate weight?",{"$nulls":7},{"$f":"'Worksheet 1b builder''s plate'!T18","v":0}]
[null,null,"Light craft condition mass",{"$nulls":4},"mLC","kg",null,{"$f":"'Worksheet 1'!I15","v":0}]
[null,null,"Maximum Loaded condition mass = mLC + mML",{"$nulls":4},"mLDC","kg",null,{"$f":"'Worksheet 1'!I34","v":0}]
[null,null,"Is boat sail or non-sail?",{"$nulls":4},"SAIL/NON-SAIL",null,null,{"$f":"'Worksheet 1'!I41","v":""}]
[null,3,"Option selected:",{"$f":"'Worksheet 3'!E38","v":0},null,"Unit",null,"Required","Actual",null,"Pass/Fail"]
[null,4,"Downflooding openings:",null,null,"Are all requirements met?",null,null,"Pass/Fail",null,{"$f":"IF(OR('Worksheet 3'!E38=10,'Worksheet 3'!E38=11),IF(AND('Worksheet 3b Overview'!A11<>\"\",'Worksheet 4'!H13<>\"Fail\"),\"Pass\",\"Fail\"),\"n.a.\")","v":"n.a."},null,{"$f":"IF(K19=\"n.a.\",\"\",IF('Worksheet 3b Overview'!A11=\"\",\"Please fill in worksheet 3a and 3b; otherwise you will receive a fail in K18\",\"\"))","v":""}]
[null,"4 & 5","Downflooding height:",null,"Worksheet employed for basic height",{"$nulls":48},"Yes"]
[null,null,"basic requirement",null,null,"m",null,{"$f":"IF('Worksheet 4'!F22=\"annex A\",'Worksheet 5'!AY33,MAX('Worksheet 4'!F24:F27))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF('Worksheet 4'!F22=\"annex A\",MIN('Worksheet 5'!E35:H35),'Worksheet 4'!F28)","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR('Worksheet 3'!E38=10,'Worksheet 3'!E38=11),IF('Worksheet 4'!F16=\"not required\",\"n.a.\",IF(J21>'Worksheet 15'!H21,\"Pass\",\"Fail\")),\"n.a.\")","v":"n.a."},{"$nulls":42},"No"]
[null,null,"reduced height for small openings (only using figures)",null,null,"m",null,{"$f":"IF('Worksheet 4'!F22=\"annex A\",\"n.a.\",MAX('Worksheet 4'!G24:G27))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF('Worksheet 4'!F22=\"annex A\",\"n.a.\",'Worksheet 4'!G28)","v":{"v":0,"d":"0.00"}},{"$f":"IF('Worksheet 4'!F16=\"not required\",\"n.a.\",IF(H22=\"n.a.\",\"n.a.\",IF('Worksheet 4'!G29=\"\",\"\",IF(J22>'Worksheet 15'!H22,\"Pass\",\"Fail\"))))","v":""}]
[null,null,"reduced height at outboard (options 1 ,3, 5 only)",null,null,"m",null,{"$f":"IF(AND('Worksheet 3'!E38<>1,'Worksheet 3'!E38<>3,'Worksheet 3'!E38<>5,'Worksheet 1'!J7<>\"OB\"),\"n.a.\",IF('Worksheet 4'!F22=\"annex A\",MAX('Worksheet 5'!E32:E34)*0.8,MAX('Worksheet 4'!H24:H27)))","v":"n.a."},null,{"$f":"IF('Worksheet 4'!F22=\"annex A\",\"n.a.\",'Worksheet 4'!H28)","v":{"v":0,"d":"0.00"}},{"$f":"IF('Worksheet 4'!F16=\"not required\",\"n.a.\",IF(H23=\"n.a.\",\"n.a.\",IF('Worksheet 4'!H29=\"\",\"\",IF(J23>'Worksheet 15'!H23,\"Pass\",\"Fail\"))))","v":"n.a."},{"$nulls":42},"Pass"]
[null,null,"increased height at bow (options 1,3, 5, 6 only)",null,null,"m",null,{"$f":"IF(OR('Worksheet 3'!E38=2,'Worksheet 3'!E38=4),\"n.a.\",IF('Worksheet 4'!F22=\"annex A\",MAX('Worksheet 5'!E32:E34)*1.15,MAX('Worksheet 4'!I24:I27)))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF('Worksheet 4'!F22=\"annex A\",\"n.a.\",'Worksheet 4'!I28)","v":{"v":0,"d":"0.00"}},{"$f":"IF('Worksheet 4'!F16=\"not required\",\"n.a.\",IF(H24=\"n.a.\",\"n.a.\",IF('Worksheet 4'!I29=\"\",\"\",IF(J24>'Worksheet 15'!H24,\"Pass\",\"Fail\"))))","v":""},{"$nulls":42},"Fail"]
[null,4,"Outboard boats when starting: Are all requirements met?",{"$nulls":5},"Pass/Fail",null,{"$f":"'Worksheet 4'!H41","v":"n.a."}]
[null,6,"Recess size: (options 10,11 in cat C)"]
[null,null,"Simplified method: max reduction in GMT",null,null,"%",null,"≤",{"$f":"IF('Worksheet 3'!E38=2,'Worksheet 6'!E62,\"\")","v":""},null,{"$f":"IF(OR('Worksheet 3'!E38=10,'Worksheet 3'!E38=11),'Worksheet 6'!E96,\"\")","v":""}]
[null,9,"Flotation test: (options 8, 9 or 11 only) All preparations completed?",{"$nulls":5},"Yes / No",null,{"$f":"IF('Worksheet 1'!D7=\"D\",\"n.a.\",IF(OR('Worksheet 3'!E38=9,'Worksheet 3'!E38=8),'Worksheet 9'!BA28,\"n.a.\"))","v":"n.a."}]
[null,null,"for Level Flotation assess items marked with LF, for Basic Flotation with BF"]
[null,null,"LF: Swamped stability: 5 min after swamping, does boat heel less than 45°?",{"$nulls":5},"Pass / Fail",null,{"$f":"IF('Worksheet 3'!E38=1,'Worksheet 9'!C29,\"n.a.\")","v":"n.a."}]
[null,null,"LF & BF:    Load test:  5 min after swamping, does boat float as required?",{"$nulls":5},"Pass / Fail",null,{"$f":"IF(OR('Worksheet 3'!E38=1,'Worksheet 3'!E38=6),'Worksheet 9'!C36,\"n.a.\")","v":"n.a."}]
[null,null,"LF:   One Person Test:  5min after swamping, does boat float so that it can be bailed?",{"$nulls":5},"Pass / Fail",null,{"$f":"IF(AND('Worksheet 1'!I9<4.8,'Worksheet 9'!C40=\"\"),\"Fail\",IF('Worksheet 3'!E38=1,'Worksheet 9'!C40,\"n.a.\"))","v":"Fail"}]
[null,null,"LF & BF:  Flotation elements:  do all elements comply with all the requirements?",{"$nulls":5},"Pass / Fail",null,{"$f":"IF(OR('Worksheet 3'!E38=1,'Worksheet 3'!E38=6),'Worksheet 9'!C44,\"n.a.\")","v":"n.a."}]
[null,10,"Basic Flotation by calculation:   value of mTEST/VB < 930",{"$nulls":5},"Pass / Fail",null,{"$f":"IF('Worksheet 3'!E38<>6,\"n.a.\",'Worksheet 10'!D42)","v":"n.a."}]
[null,11,"Capsize Recovery Test: (opt. 7 only)  requirements met?",{"$nulls":5},"Pass / Fail",null,{"$f":"IF('Worksheet 3'!E38<>7,\"n.a.\",'Worksheet 11'!B38)","v":"n.a."}]
[null,null,"Design Category recommended by the builder",{"$nulls":5},{"$f":"IF('Worksheet 3'!E38=7,'Worksheet 11'!B36,\"n.a.\")","v":"n.a."}]
[null,12,"Knockdown Recovery Test  (option 8 and 10 only)  requirements met?",{"$nulls":7},{"$f":"IF('Worksheet 12'!J11=\"n.a.\",\"n.a.\",IF('Worksheet 1'!D7=\"C\",'Worksheet 12'!J13,'Worksheet 12'!J15))","v":"n.a."}]
[null,null,"method used (theoretical or practical)",{"$nulls":5},{"$f":"IF(AND('Worksheet 12'!C12=\"\",'Worksheet 12'!D12=\"\",'Worksheet 12'!C22=\"\",'Worksheet 12'!D22=\"\"),\"\",IF('Worksheet 12'!C22<>\"\",\"Theoretical\",IF('Worksheet 12'!D22<>\"\",\"Theoretical\",\"Practical\")))","v":""}]
[null,13,"Windstiffness Test (option 9 and 11 only)",{"$nulls":7},{"$f":"IF(OR('Worksheet 3'!E38=9,'Worksheet 3'!E38=11),IF('Worksheet 13'!C9=\"Experimental\",'Worksheet 13'!P23,IF('Worksheet 13'!C9=\"Theoretical\",'Worksheet 13'!M43,\"\")),\"n.a.\")","v":"n.a."}]
[null,null,"reefed or unreefed option used?",{"$nulls":5},{"$f":"'Worksheet 13'!M45","v":"unreefed"}]
[null,14,"Detection & removal of water (all options)  Are all requirements met?",{"$nulls":5},"Yes / No"]
[null,"NB: Boat must pass all requirements applicable to selected option to be given intended Design Category."]
[]
[]
[null,"Design Category given:",null,null,"Assessed by:"]
[]
[{"$nulls":4},"signature:"]
[]
[]
[]
[]
[{"$nulls":53},"C"]
[{"$nulls":53},"D"]